--sqlserver SELECT TOP 100 * FROM dbo.T_TASK --oracle select * from TASK where rownum<100 --mysql SELECT * FROM T_TASK limit 0,100