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

find the third highest salary?

Question Posted / mousumi dalai

Answer Posted / mousumi dalai

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many indexes can be created on a table in sql?

1055

How does index help in query performance?

1028

What is sql exception?

974

What is full form of rtm?

1008

What is update query?

981

Can we enter data in a table in design view?

969

Explain architecture of sql server notification services?

1060

What is nested table in pl sql?

1071

How do you modify a column in sql?

997

how can we optimize or increase the speed of a mysql select query? : Sql dba

948

What is scalar data type in pl sql?

1070

What is a memo field?

969

What is pivot query?

1071

What is an exception in PL/SQL? What are the two types of exceptions?

1311

What is pl sql block structure?

1035