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

What is the strong name in .net assembly?

566


Explain cts?

532


thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net

1703


What is private assembly?

517


Explain the difference between import system.data.sqlclient and system.data.oledb?

547






What are the different variables in vb.net?

518


What is the difference between convert.tostring and .tostring() method?

522


How to store images in sql server database through vb.net?

503


Explain the advantage of option strict on?

527


Describe about visual basic.net?

557


Tell me which namespace are used for accessing the data?

523


Explain about the feature anonymous type?

617


Allowed program to auto-correct the database when loading a presentation.

1743


How to achieve Polymorphism in VB.Net?

620


What are the difference between structure and class?

560