假設你的表名字為t1,其中有一個欄位為id,你打算按照id的升序排列,依次顯示1-5條、6-10條等SELECT * FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY id) as r FROM t1) WHERE r BETWEEN 1 AND 5ORDER BY id需要顯示第m到第n條,只需替換BETWEEN和AND後面的數即可。
公曆怎麼來的?
部落衝突初7怎麼快速得黑油出人王?
滇東南幾月份旅遊最好?