Saturday, June 18, 2011
How to find 2 nd highest Sal ?
Select empno, ename, sal, r from (select empno, ename, sal, dense_rank () over (order by sal desc) r from EMP) where r=2;
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment