select top 10 from tbl_name order by salary desc

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 / gunjan sapra

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

Answer Posted / gunjan sapra

select top 10 from tbl_name order by salary desc

Is This Answer Correct ?

4 Yes

39 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is snapshot parameter in ssrs?

155

Define ACID properties in a Database?

1105

What is clustered vs nonclustered index?

1003

How to find tables without indexes?

1155

What is a non clustered primary key?

974

What is the Control Flow in SSIS

1147

What is raid? : SQL Server Architecture

1230

What is sql or structured query language?

1200

What is the stuff?

1060

What are the properties of the relational tables?

928

What is the default order of an order by clause?

1035

How you can find out if an index is useful to the optimizer?

987

What are page splits? : SQL Server Architecture

1039

What do you mean by data integrity?

1128

what is the difference between Delete and Truncate command in SQL

1201