SQL paging query

From Tacky Gibbon, 1 Year ago, written in SQL, viewed 232 times.

先定位偏移位置的 id，然后往后查询，这种方式适用于 id 递增的情况。
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

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?

Spam protection Type in the letters

https://burned.cc - Burn After Reading Website

Pastebin.vip

SQL paging query

Reply to "SQL paging query"