Using CASE instead of Oracle’s DECODE

(Craig Mullins) In Oracle DECODE can be used in a where clause. For example: WHERE DECODE (deptno,10,’HR’, 20,’Sales’) = ‘Sales’ How can this be achieved in a DB2 query with the CASE statement? (R)

Read More - Register for Free Membership