Thread
:
How to find second max sal of employee with the co
View Single Post
#
3
(
permalink
)
09-28-2007, 01:31 AM
tejinder
Junior Member
Join Date: Aug 2004
Posts: 1
select * from emp
where sal in ( select min(sal) from
(select sal from emp
order by sal desc)
where rownum <=2 )
Try this and reply.
tejinder
View Public Profile
Send a private message to tejinder
Find all posts by tejinder