SELECT MIN(sal) FROM Emp WHERE sal in (SELECT TOP 2 DISTINCT sal 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 / ravi kumar

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

Answer Posted / ravi kumar

SELECT MIN(sal) FROM Emp WHERE sal in
(SELECT TOP 2 DISTINCT sal from Emp ORDER BY DESC)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are page splits? : SQL Server Architecture

996

How many types of built in functions are there in sql server 2012?

928

How can I change procedure name in sql server?

1058

How to get @@error and @@rowcount at the same time?

1044

Should you normalize audio?

946

What are the dis_advantages of stored procedures, triggers, indexes?

2229

What is normalization according to you and explain its different levels?

963

How to return the second 5 rows in ms sql server?

1071

What is use of except clause?

1096

What functions can a view be used to performed?

1064

What do you understand by mirroring?

1002

What are the instances when triggers are appropriate?

982

What are the types of normalization?

1036

Can a trigger be created on a view?

964

Explain about builtinadministrator?

1063