3種類のデータベースのSQLページング
1464 ワード
SQL Server
M N , Top : Select top, order by, :
SELECT *
FROM ( SELECT Top N * FROM (SELECT Top (M + N - 1) * FROM Order by desc) t1 ) t2
Order by asc
Sys_option( sys_id) 10 20 , :
SELECT *
FROM ( SELECT TOP 20 *
FROM (SELECT TOP 29 * FROM Sys_option order by sys_id desc) t1) t2
Order by sys_id asc
Oralce
M N
SELECT *
FROM (SELECT ROWNUM r,t1.* From t1 where rownum < M + N) t2
where t2.r >= M
Sys_option( sys_id) 10 20 , :
SELECT *
FROM (SELECT ROWNUM R,t1.* From Sys_option where rownum < 30 ) t2
Where t2.R >= 10
MySQL
My SQL , mySQL LIMIT ,LIMIT [offset,] rows M N :
SELECT * FROM LIMIT M,N
Sys_option( sys_id) 10 20 , :
select * from sys_option limit 10,20