Question

sql取前几条数据

Answer 1

如果是SQL SERVER的话SELECT TOP 5 * FROM TABLE
如果是MY SQL的话，select * from table limit m,n

Answer 2

select * from TABLE where ROWNUM <= 5;

Answer 3

select * from table up to 5 rows.

Answer 4

SELECT TOP 5 * FROM TABLE