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

Explain activity monitors

1006

Are semicolons required at the end of sql statements in sql server 2005?

934

What do you understand by replication in sql server?

997

How to delete duplicate rows from table except one?

933

What is table-valued sub query?

924

How many databases instances are there in sql server 2000?

1025

How to move database physical files in ms sql server?

961

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

953

How to name query output columns in ms sql server?

918

How many full-text indexes can a table have?

930

What are the different subsets of sql?

1473

Explain unique key in sql server?

955

What is a not null constraint?

976

How to get nth highest salary from employee table.

1105

What command is used to rename the database?

947