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:
Post 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. Suppose we have EmpTbl as below And Data like Now we have queries like 1. Select maximum salary from EmpTbl Ans....
No comments:
Post a Comment
Thanks