SQLServer

select top 10 * from tabl1

Db2

select * from sysibm.syscolumns
fetch first 10 rows only