select min(sal) from (select sal from emp order by sal desc) where rownum

find the third highest salary?

Question Posted / rohit kumar

Answer Posted / rohit kumar

select min(sal) from (select sal from emp order by sal
desc) where rownum <= 3

Is This Answer Correct ?

17 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is bulk collect in pl sql?

1072

explain about mysql and its features. : Sql dba

1002

What is out parameter used for eventhough return statement can also be used in pl/sql?

1058

What are the query optimization techniques?

913

Why do we use cursors?

975

How do I truncate a word?

1063

How do I view a table in sql?

993

How do I create a memory optimized filegroup?

944

How do I run a sql query in pgadmin 4?

944

What do you mean by “trigger” in sql?

1054

when MSQL8.0 is in market

2063

What is the location of pre_defined_functions.

1150

What is sql*loader?

1155

What is rownum?

963

Is join same as left join?

1020