select min(sal) from (Select rownum,sal FROM emp> Order by sal desc)

Find out the 3rd highest salary?

Question Posted / durgashivashankar

Answer Posted / durgashivashankar

select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many clustered indexes can you have?

975

Which tcp/ip port does sql server run?

1014

what is the use of double ampersand (&&) in sql queries?

1176

What is java sql drivermanager?

1102

What is the difference between nested table and varray?

1006

What is parameter substitution in sql?

1033

what are the advantages a stored procedure? : Sql dba

978

What is attribute indicator in pl sql?

1017

Enlist the data types that can be used in pl/sql?

1073

What is package in pl sql?

1028

What found sql?

947

Can a varchar be a primary key?

1009

How do you create a db file?

1020

What is full form of rtm?

1008

which tcp/ip port does sql server run on? : Sql dba

1029