Cap rows returned

how do i just grab the top 10 rows of this query? a few million records returned to just grab the first few is slow and wasteful across the board.

select
  sic_opt_ains.code
from
  plink.sic_opt_ains,
  plink.sic2sic
where
  sic2sic.child=sic_opt_ains.code
order by
  sic_opt_ains.ains desc Received on Wed Jul 11 2001 - 16:27:47 CDT