各个数据库的方法并非一样Mysql:SELECT*FROMtblLIMIT0,100;SQL Server:SELECT*FROMtblWHEREidIN(SELECTTOP100idFROMtbl)
;Oracle:SELECT*FROMtblWHERErownum<=100
时间:2020-03-27 03:27:30
各个数据库的方法并非一样Mysql:SELECT*FROMtblLIMIT0,100;SQL Server:SELECT*FROMtblWHEREidIN(SELECTTOP100idFROMtbl)
;Oracle:SELECT*FROMtblWHERErownum<=100