12-Aug-04 (Created: 12-Aug-04) | More in 'CS-SQLServer'

How to limit rows from database queries

SQLServer


select top 10 * from tabl1

Db2


select * from sysibm.syscolumns
fetch first 10 rows only