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

Find out the 3rd highest salary?

Question Posted / shaiju nair

Answer Posted / shaiju nair

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

Is This Answer Correct ?

13 Yes

25 No

Please Help Members By Posting Answers For Below Questions

What is dbo in sql?

973

What is Histogram?

1564

Is postgresql a nosql database?

1164

Is natural join and inner join same?

930

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1783

When should I use nosql database?

1014

Which normal form is best?

951

What is the difference between left and left outer join?

948

What are the events on which a database trigger can be based?

1190

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1074

How do you declare a variable in pl sql?

1032

what are the nonstandard string types? : Sql dba

1144

What is difference between nchar and nvarchar?

1029

Which table is left in join?

983

how to convert character strings to dates? : Sql dba

1065