SQL: How can i get the 10 greatest values.

[erwan]

In sql, i want to get only 10 gretest values on a table .

I try with ROWNUM with " where rownum > count(*) -10 but the "order by" is made after the rownum and the result is false.

how can i do that.
thank you!

 

[bigscouse]

the mackpei thread posted 22/8 might help.

 

[buttersoft]

MAX(fieldname)

 

[cgordon]

In Oracle use a subquery.

From the Oracle course:

select ename, sal
from emp e
where 10 >
(select count(*)
from emp
where e.sal < sal)
order by e.sal

In SQLServer use:
select TOP 10 ename, sal
from emp
order by sal