How to limit rows from database queries

SQLServer


select top 10 * from tabl1

Db2


select * from sysibm.syscolumns
fetch first 10 rows only