Wednesday, 17 February 2016

SQL QUERIES USING DECODE


SELECT   job ,ename,DECODE (job ,'PRESIDENT', 1,'MANAGER', 2,'ANALYST', 3,      
                                                       'SALESMAN', 4 ,'CLERK', 5) job_order FROM emp
ORDER BY DECODE ( job,'PRESIDENT', 1 ,'MANAGER', 2,'ANALYST', 3,'SALESMAN', 4,
                                        'CLERK', 5).
       

Posted by at

No comments:

Post a Comment

If you Like my blog Spread it and help friends for whom this blog is useful for their career.

Subscribe to: Post Comments (Atom)