select min(sal) from (select sal from (select sal from salary order by sa

Find out the 3rd highest salary?

Question Posted / tathagoto

Answer Posted / tathagoto

select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how to shutdown mysql server? : Sql dba

1077

What are literals in sql server?

1138

how to use in conditions? : Sql dba

992

What is indexing in sql and its types?

1055

What is scalar and vector?

986

How many sql statements are used?

998

What packages(if any) has oracle provided for use by developers?

5781

How do I upgrade sql?

986

What are the benefits of triggers?

1155

how does a local variable is defined using t-sql? : Transact sql

987

Can you do multiple joins in sql?

1018

What is foreign key and example?

916

What is the difference between numeric and autonumber?

980

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1022

how to get a list of all tables in a database? : Sql dba

953