SQL显示查询结果的前100条
时间:2021-05-27 12:31:49
select * from tbl limit 100;
ORACLE: select * from tbl where rownum<=100;
SQL SERVER:
select top 100 * from tbl
SYBASE: SET ROWCOUNT N GOSELECT * FROM TABLE1
select * from tbl limit 100;
ORACLE: select * from tbl where rownum<=100;
SQL SERVER:
select top 100 * from tbl
SYBASE: SET ROWCOUNT N GOSELECT * FROM TABLE1