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 are the advantages a stored procedure? : Sql dba

949

What is data profiling in sql?

1036

What's the procedure?

891

What are the differences between in and exists clause?

1074

What are primary key and foreign key and how they work?

947

What does the file extension accdb stand for?

938

How many triggers can be applied on a table?

903

what is table? : Sql dba

1029

What is sql in java?

1049

Inline the values in PL/SQL, what does it mean.?

1181

What are the events on which a database trigger can be based?

1149

What does data normalization mean?

923

What is sql clause?

1014

What is the command used to fetch the first 5 characters of a string?

1181

How do you rank data in sql?

961