how to find the 2nd higgest salary in the column for example take table name is

how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?

Question Posted / om namo bhagavathe vasudevaya

11 Answers
15794 Views
GeoTechnology, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find the 2nd higgest salary in the column for example take table name is employee? And also..

Answer / prasoon madnawat

SQL Server:
Select MIN(Salery) from (SELECT TOP 2 * from EMPLOYEE)

Oracle:
Select MIN(Salery) from (SELECT * from EMPLOYEE where ROWNUM <3)

MySQL
Select MIN(Salery) from (SELECT * from EMPLOYEE LIMIT 2)

Is This Answer Correct ?

0 Yes

5 No

Post New Answer

More Dot Net AllOther Interview Questions

11. diff b/w Dll and Exe

6 Answers PCS,

Explain cache? : .NET Architecture

0 Answers

what is the need of vss to developer?

1 Answers

Let's say I have an existing application written using Visual Studio 6 (VB 6, InterDev 6) and this application utilizes Windows 2000 COM+ transaction services. How would you approach migrating this application to .NET ?

1 Answers

difference between page init an page load

1 Answers PCS,

How to upload in video,mp4,in .net 4.5 ..?

0 Answers HCL,

how to minimize,maximize and restore my form programmatically?

1 Answers Interlac, Six Sigma,

Explain about .net garbage collector?

0 Answers

Name some changes done since version 3.0?

0 Answers

Explain about appdomains?