一、DB2:

? ? ?①.按行號(hào)并且按照指定字段降序，取前10條數(shù)據(jù)SQL

SELECT * FROM (Select 字段1,字段2,字段3,rownumber() over(ORDER BY 指定降序字段 DESC) AS rn from 表名) AS a WHERE a.rn BETWEEN 0 AND 10

? ? ? ②.不需降序取前10條數(shù)據(jù)SQL

SELECT * FROM (Select 字段1,字段2,字段3,rownumber() over() AS rn from 表名) AS a WHERE a.rn BETWEEN 0 AND 10

注：若查詢數(shù)據(jù)含有重復(fù)數(shù)據(jù)則需用方式①，含有重復(fù)數(shù)據(jù)的字段名則為指定字段

二、Mysql:

select * from table limit 0,10

三、Oracle：

從第0行開始取十條記錄數(shù)據(jù)

select * from (select rownum,name from table where rownum <=10) where rownum > 0

四、SQL SERVER

SELECT TOP 頁大小 *

FROM Table

WHERE (ID >

(SELECT MAX(id)

FROM (SELECT TOP 頁大小*頁數(shù) id

FROM 表

ORDER BY id) AS T))

ORDER BY ID