View Single Post

  #3 (permalink)  
Old 09-28-2007, 01:31 AM
tejinder tejinder is offline
Junior Member
 
Join Date: Aug 2004
Posts: 1
tejinder
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.
Reply With Quote