select Sal from Employee where Sal != (select max(Sal) from Employee) Order

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 / riyazkhan

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

Answer Posted / riyazkhan

select Sal from Employee where Sal != (select max(Sal) from Employee) Order By Sal desc

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe how to use linked server?

1082

What causes index fragmentation?

1047

What are the differences between decimal and float in ms sql server?

1351

what are cursors? : Sql server database administration

1106

How is SQL Azure different than SQL server?

225

What is a dataset and what are the different types of datasets?

141

Explain transaction isolation levels in sql server?

1185

What is attribute? : sql server analysis services, ssas

1069

What are the limitations/drawbacks or ssrs 2008 r2?

152

What are the different Topologies in which Replication can be configured?

1242

How to create function without parameter in sql server?

1110

What is the library index called?

1113

Where are stored procedures in sql server?

1128

What is a field name?

1020

List all the types of user-defined functions?

1186