如果是SQL SERVER的话SELECT TOP 5 * FROM TABLE如果是MY SQL的话，select * from table limit m,n
select * from TABLE where ROWNUM <= 5;
select * from table up to 5 rows.
SELECT TOP 5 * FROM TABLE
