select * from emp where sal in(select min(sal) from (select sal from emp o

find the third highest salary?

Question Posted / pradeep

Answer Posted / pradeep

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are character functions in sql?

986

What is a heap in sql?

1132

What is server name sql?

1197

What are the ddl commands?

1050

How do I create an index in word?

1072

what are date and time intervals? : Sql dba

1096

What is coalesce sql?

1048

What is compiled query?

1081

Does truncate remove indexes?

1073

What is data modelling in sql?

1065

What is the left table in sql?

1008

What are triggers in sql?

1054

What is the use of index in hive?

1050

How many sql commands are there?

1152

What is the difference between left join and right join?

986