Skip to content

Instantly share code, notes, and snippets.

@songyunlu

songyunlu/LIMIT.sql

Created March 2, 2013 07:16
Show Gist options
  • Save songyunlu/5070021 to your computer and use it in GitHub Desktop.
Save songyunlu/5070021 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
LIMIT.sql
SELECT * FROM table WHERE id >= 23423 LIMIT 11;
/* 10 + 1 每頁十筆資料 */
SELECT * FROM table WHERE id >= 23433 LIMIT 11;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment