Skip to content

Instantly share code, notes, and snippets.

@jayden-lee

jayden-lee/mysql-select-limit-1.sql

Created October 6, 2018 16:03
Show Gist options
  • Save jayden-lee/8e19d50492eb09be9c7543351c3e368e to your computer and use it in GitHub Desktop.
Save jayden-lee/8e19d50492eb09be9c7543351c3e368e to your computer and use it in GitHub Desktop.
Download ZIP
[MySQL] SELECT 문에서 Limit 사용법
Raw
mysql-select-limit-1.sql
-- 데이터 10 개만 조회하기
SELECT title, content, writer FROM board LIMIT 10;
Raw
mysql-select-limit-2.sql
-- 11번째 해당하는 행부터 10개 조회하기
SELECT title, content, writer FROM board LIMIT 10, 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment