manojmkp
Pages
Home
Blog Archive
Blog Archive
February (1)
January (1)
August (1)
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:
Post a Comment
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment