sql satement for 2nd maximum value

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

Can you please explain the difference between authentication and authorization?

617


Explain public assembly?

625


What are the two main parts of .net?

643


Name a feature which is common to all .net languages?

653


Can you please explain the difference between dataset and datareader?

634






So you know which dll is used for microsoft .net run time?

611


What is a static class?

667


What are the different types of Lock available in Visual Basic?

718


Explain the difference between dispose and finalize()?

633


Explain about rapid application development tool?

602


Can you please explain the difference between c# and vb.net?

637


source code for how to login a vb.net application ?

666


Can you please explain the difference between dispose and finalize()?

576


What languages does the .net framework support?

617


How vb implements the disconnected architecture as like vb.net?

657