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

Which is better varchar or nvarchar?

977

What is the difference between delete, truncate and drop command?

1126

what is error ora-03113: end-of-file on communication channel?

1149

describe transaction-safe table types in mysql : sql dba

988

Explain exception handling in pl/sql?

1022

what is the difference between clustered and non clustered index in sql? : Sql dba

1107

Mention what is the function that is used to transfer a pl/sql table log to a database table?

971

Can you have a foreign key without a primary key?

938

What is set serveroutput on in pl sql?

1272

What is over () in sql?

932

what is top in tsql? : Transact sql

1088

What is a trigger word?

1003

What is java sql connection?

1031

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

1024

What is a ddl command?

1069