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
60340 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

Why I can not enter 0.001 second in date and time literals in ms sql server?

1071

What is policy management?

1008

What’s the use of custom fields in report?

948

Explain the phases a transaction has to undergo?

1068

How sql server enhances scalability of the database system?

1227

What happens if date-only values are provided as date and time literals?

1029

Can you move the resources after pausing the node? : sql server database administration

1111

How to see existing views in ms sql server?

1054

What is built-in/administrator?

1021

Can you explain what are various ways to enhance the ssrs report?

1004

What is read uncmmited?

1069

What is factless fact table? : sql server analysis services, ssas

1042

Which command is used for user defined error messages?

1068

Are null values the same as that of zero or a blank space?

1043

How to read data in a table with "select" statements?

977