select min(sal) from emp where sal in (select sal from emp order by sal de

find the third highest salary?

Question Posted / mousumi dalai

Answer Posted / mousumi dalai

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

Is This Answer Correct ?

9 Yes

36 No

Please Help Members By Posting Answers For Below Questions

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

956

What is an invalid partition table?

1011

What is a sql trace file?

1011

What is difference between inner join and cross join?

953

what is the difference between blob and text? : Sql dba

1003

How can you view the errors encountered in a trigger?

946

What is scalar function?

1033

Can I join the same table twice?

1032

What is pivot in sql?

902

Is sql a dbms?

978

What is join view in sql?

932

How do I remove all records from a table?

1062

How can we implement rollback or commit statement in a trigger?

1017

Why we use sql profiler?

939

what are the nonstandard string types? : Sql dba

1122