Hey guys use this query ,i used it so many time ,it will be useful to you

sql satement for 2nd maximum value

Question Posted / sanjeev singla

15 Answers
22600 Views
NIIT, I also Faced
E-Mail Answers

Answer Posted / sanjeev singla

Hey guys use this query ,i used it so many time ,it will be
useful to you..try this one...

SELECT MAX(Salary) AS Expr1
FROM Employees
WHERE (Salary <
(SELECT MAX(Salary)
FROM Employees))

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we use byref keyword in vb.net?

1060

What is branching logic control in VB.NET?

981

Write a program to find all text files in a logical drive and return the count of the number of files?

2716

Compare c# and visual basic.net?

957

Explain namespace?

1121

What is the exact defination of object?

1013

What is tracing?

1139

What is early binding?

952

Write a VB.Net console program to check whether a number is perfect or not.

7816

What is redim keyword?

1003

What is the use of console application?

1113

Can you please explain the difference between system.string and system.stringbuilder classes?

1057

What is the difference between static or dynamic assemblies?

1024

What is sealed class?

1139

What are the differences between vb.net and c#, related to oops concepts

973