a.DB2 分页查询sql（ROWNUMBER()）
SELECT * FROM (SELECT ROWNUMBER() OVER(order BY 子段 desc) AS contId,t.* FROM tablename t)
WHERE contId<=20 AND contId >10
b.MySql 分页查询sql （limit ）
select * from tablename limit 10,20
c.Oracle 分页查询sql （ROWNUM ）
SELECT * FROM (SELECT ROWNUM R,t1.* From tablename t1 where rownum < 30 ) t2 Where t2.R >= 10
d.SQL server分页查询sql （TOP ）
SELECT TOP 20 * FROM (SELECT TOP 29 * FROM tablename) t1
SELECT * FROM (SELECT ROWNUMBER() OVER(order BY 子段 desc) AS contId,t.* FROM tablename t)
WHERE contId<=20 AND contId >10
b.MySql 分页查询sql （limit ）
select * from tablename limit 10,20
c.Oracle 分页查询sql （ROWNUM ）
SELECT * FROM (SELECT ROWNUM R,t1.* From tablename t1 where rownum < 30 ) t2 Where t2.R >= 10
d.SQL server分页查询sql （TOP ）
SELECT TOP 20 * FROM (SELECT TOP 29 * FROM tablename) t1
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
