Email: Password:       Forgot Password 
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
Finding the nth highest salary of an employee..

Posted On: 26/09/2012 20:43:25

--Highest Salary

select max(Emp_Sal) from tbl_Employee

Posted On: 26/09/2012 20:46:00

nth Highest Salary

SELECT min(Emp_Sal) FROM tbl_Employee WHERE Emp_Sal in
(SELECT DISTINCT top n Emp_Sal FROM tbl_Employee ORDER BY Emp_Sal desc)

         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us