Get Third Highest Salary
SELECT TOP (1) * FROM
(SELECT TOP (3) Empsalary FROM employeeMaster ORDER BY empsalary DESC) T
ORDER BY empsalary ASC
Friday, 31 October 2014
Get Third Highest Salary Sql Query
Get Third Highest Salary
SELECT TOP (1) * FROM
(SELECT TOP (3) Empsalary FROM employeeMaster ORDER BY empsalary DESC) T
ORDER BY empsalary ASC
Subscribe to:
Comments (Atom)
-
1. DateSet contains one or more DataTables? A. True B. False C. Can't say D. None of the above ----------------------------------...
-
1. Open visual studio 2. Create a new project. 3. Right Click solution and select Manage Nuget Packages 4. Search Elmah and add the e... -
1. What is JavaScript? Ans Javascript is a client-side scripting language that is understood by browsers. 2. What is the use of isNaN f...