to get the first 10 rows......

select column1 from table1 fetch first 10 rows only

to get the top 10 rows........

select column1 from table1 order by column1 desc fetch first 10 rows
only

Graham Martin
http://www.ibm.com/software/data/db2/migration/