sql查询前100条数据

mysql 

select * from table limit 0,100;

 

oracle

select * from table where rownum<=100;

 

sqlsever

select top 100 * from table;