select top 1 salary from (select top 5 salary from emp

How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database

plz mail the answer @ mak2786@gmail.com

Question Posted / suhail

35 Answers
58912 Views
Oracle, Scend, TechInfini, I also Faced
E-Mail Answers

Answer Posted / suhail

select top 1 salary from (select top 5 salary from
emp_table order by salary desc)temptable order by salary asc

Is This Answer Correct ?

17 Yes

36 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How would you go about developing a ssrs report?

159

What is 1nf normalization form?

981

Difference between group by clause and having clause in SQL?

929

Write SQL queries on Self Join and Inner Join.

1072

Can foreign key be deleted?

873

What happens if we shrink log file in sql server?

913

What is data set in report?

121

How to copy data from one table to another table?

935

Does a specific recovery model need to be used for a replicated database? : sql server replication

914

Explain about service Broker functions?

985

What is the boxing and unboxing concept in .net?

867

What is instead of dml trigger?

953

What is the difference between clustered and a non-clustered index?

979

What do you understand by intent locks?

956

What is the filtered index?

977