Pages

Blog Archive

Wednesday, February 18, 2009

Query to find the 3rd heighest salary to 8th heighes salary from employee table

select top 6 salary,EmpName from Emp_table where salary not in(select top 2 salary from Emp_table order by salary desc) order by salary desc

No comments: