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
58920 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 click through reports?

138

Explain sub-query?

902

How each E-R model constructs can be mapped to the relational model?

922

Which autogrowth database setting is good?

1006

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

936

How will you hide an attribute? : sql server analysis services, ssas

893

Can a table be moved to different filegroup?

920

What are the different type of replication in sql server?

935

Characterize join and name diverse sorts of joins?

912

What are the new security features added in sql server 2012? : sql server security

949

Can we call future method from trigger?

881

What is normalization? Explain its different types?

1039

What is schemabinding a view?

866

What is table value parameters (tvp)?

1039

what's the maximum size of a row? : Sql server database administration

1014