java基础之面试篇六-oracle,mysql,sqlserver,db2取前十条记录sql语句

1.oracle:

select*fromtable1whererownum<=10;

2.sqlserver:

selecttop10*fromtable1

3.mysql:

select*fromtable1limit10

4.db2:

select*fromtable1fetchfirst10rowsonly