SQL paging query

From Tacky Gibbon, 1 Year ago, written in SQL, viewed 217 times.
URL https://pastebin.vip/view/71221319
  1. 先定位偏移位置的 id,然后往后查询,这种方式适用于 id 递增的情况。
  2. SELECT * FROM orders_history WHERE TYPE=8 AND id>=(SELECT id FROM orders_history WHERE TYPE=8 LIMIT 100000,1) LIMIT 100;

Reply to "SQL paging query"

Here you can reply to the paste above

captcha

↑↑↑↑↑↑↑↑↑↑↑↑↑ vps