Answer Detail: RE: What is the Querry for retrieving the 2nd highest ...

GeekInterview.com > Tech FAQs > SQL

Print |

Question: What is the Querry for retrieving the 2nd highest salary in a table?

March 03, 2006 02:54:01	#7
tapas	Member Since: Visitor Total Comments: N/A
RE: What is the Querry for retrieving the 2nd highest ...
select * from (select rownum rn,x.* from(select * from emp)x)where rn=2;