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

Mention what plvcmt and plvrb does in pl/sql?

1148

What is faster join or subquery?

1018

how to decrement dates by 1 in mysql? : Sql dba

1025

What is the plv (pl/vision) package offers?

1058

Is drop table faster than truncate?

998

What can you do with pl sql?

1101

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1124

What is a dirty read sql?

1164

Explain the purpose of %type and %rowtype data types?

939

What is bulk collect in pl sql?

1101

What is mutating table error?

1195

what is single byte over head in oracle..?

2412

Is clustered index a primary key?

955

Can we use distinct and group by together?

1062

What are transaction and its controls?

1047