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 synonyms?

573

What is the maximum number of rows in sql table?

551

What are pl/sql cursor exceptions?

575

What are all ddl commands?

550

Does inner join return duplicate rows?

521

what is a foreign key ? : Sql dba

609

Can we insert data into materialized view?

519

How do you explain an index?

790

what are the types of subquery? : Sql dba

592

What is 19 null in sql?

535

What is the difference between mdf and ndf files?

573

What is crud stand for?

570

What is the least restrictive isolation level? : Transact sql

565

What is sqlca in powerbuilder?

572

Do stored procedures prevent sql injection?

551