Skip to content

Instantly share code, notes, and snippets.

@jojoldu
Last active February 3, 2020 23:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jojoldu/9eb0d071f194e2ed4008b38f476169d7 to your computer and use it in GitHub Desktop.
Save jojoldu/9eb0d071f194e2ed4008b38f476169d7 to your computer and use it in GitHub Desktop.
SELECT *
FROM product
ORDER BY id
LIMIT 10000, 2
SELECT  *
FROM product as i
JOIN (SELECT id
      FROM product
      ORDER BY id
      LIMIT 10000, 2) as temp 
on temp.id = i.id
select name
from member
where age = 20;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment