DB2 Using except in sp

Viewed 18

I want to use a simple except statement in my stored procedure. But got error

DECLARE SAME INT;
SELECT 1 INTO SAME
        SELECT ND 
        FROM MYTABLE
        WHERE ID = 1
EXCEPT
        SELECT ND
        FROM MYTABLE
        WHERE ID = 2
0 Answers
Related