select top 1 * from(select top 3 *from emp order by salary desc)d order

Find out the 3rd highest salary?

Question Posted / sheik

Answer Posted / sheik

select top 1 * from(select top 3 *from emp order by salary
desc)d order by salary asc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between view and stored procedure?

909

Describe sql comments?

959

How does cross join work?

874

Is stored procedure faster than query?

913

What are all the different normalizations?

966

What are aggregate functions in sql?

1087

What are the three forms of normalization?

992

how to shutdown mysql server? : Sql dba

1027

What is the difference between local variables and global variables?

1065

how to shut down the server with 'mysqladmin'? : Sql dba

954

What is the difference between functions, procedures, and packages in pl/sql?

973

How do I count rows in sql query?

937

What can I use instead of union in sql?

902

how to install mysql? : Sql dba

1041

What is synchronized subquery?

1089