Re: Delete in IF or CASE function

[Vemsom Helst]

Still missing that edit button here...

I saw my error in the subquery, I selected three columns. I do however get 'subquery return more than 1 row'

delete from tab
where SIGNAL_ID=0 and SIGNAL_ID=(
SELECT a.SIGNAL_ID
FROM (select * from tab) a
INNER JOIN (select * from tab) b ON a.orders = b.orders
WHERE a.SIGNAL_ID <> b.SIGNAL_ID);