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 sql statement is used to delete data from a database?

966

What are the advantages of pl sql over sql?

1028

Can a primary key be a foreign key?

1029

List different type of expressions with the example.

936

What is sql and db2?

1013

What is a unique constraint?

1081

Explain the significance of the & and && operators in pl sql.

1010

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3058

What is difference between pls_integer and integer?

969

how to select unique records from a table? : Sql dba

1118

how can we know the number of days between two given dates using mysql? : Sql dba

1049

what is the difference between nested subquery and correlated subquery?

1059

What is difference between sql and mysql?

1137

What is where clause in sql?

1048

What is a sql instance vs database?

1122