How do I get a top ten ?

select a.ordered_column, a.other_stuff
from table_name a
where 10 > (
select count(1)
from table_name b
where b.ordered_column
< a.ordered_column )
order by a.ordered_columnl;