MySQL | LIMIT

ํ˜ธ๋–กยท2022๋…„ 9์›” 15์ผ
0

๐Ÿ“๊ด€๋ จ ์‹ค์Šต: 5-3. World DB SELECT ๊ธฐ๋ณธ


  1. country์—์„œ code๊ฐ€ ๋ชจ์Œ์œผ๋กœ ์‹œ์ž‘ํ•˜๋Š” ๋‚˜๋ผ์˜ ์ •๋ณด๋ฅผ ์ถœ๋ ฅํ•˜์‹œ์˜ค. ์ด๋•Œ name์˜ ์˜ค๋ฆ„์ฐจ์ˆœ์œผ๋กœ ์ •๋ ฌํ•˜๊ณ  3๋ฒˆ ๋ถ€ํ„ฐ 3๊ฐœ๋งŒ ์ถœ๋ ฅํ•œ๋‹ค.
    LIMITย ์‹œ์ž‘์ ,ย ๊ฐฏ์ˆ˜ย (์ฒซ๋ฒˆ์งธย ํŒŒ๋ผ๋ฏธํ„ฐ๋Š”ย 0ย ๋ถ€ํ„ฐย ์‹œ์ž‘ํ•จ)

SELECT code, name
FROM country
WHERE code RLIKE '^[AEIOU].*'
ORDER BY name
LIMIT 2, 3;

0๊ฐœ์˜ ๋Œ“๊ธ€