TECHNE CORNER
Pages
Home
Search This Blog
Monday, 19 September 2011
Nth largest number in a table
Select min(salary) from employee where salary in(select distinct top 10 salary from employee order by salary desc);
It finds the 10th largest salary in an employee table
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment