Pages

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