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

Why schema is used in sql?

1004

What is the difference between microsoft access and sql server?

1013

Can I learn sql in a week?

1031

Differentiate between pl/sql and sql?

1091

Why do we use procedures in sql?

1046

How to connect a sql*plus session to an oracle server?

1096

What are user defined functions?

963

what is the difference between truncate and delete statement? : Transact sql

1033

what is self-join? : Sql dba

1089

What is an inconsistent dependency?

1010

How long does it take to learn pl sql?

1025

is mysql query is case sensitive? : Sql dba

1050

What is procedure explain with program?

970

What are pl sql data types?

974

how is myisam table stored? : Sql dba

1016