[MySQL] 특정 개수의 값 출력

TOP

SELECT TOP [N(개수)/N%(비율)] ~ FROM ~
e.g. SELECT TOP 3 * FROM TABLE ORDER BY SCORE TOP N% WITH TIES

LIMIT

SELECT ~ FROM ~ LIMIT N(시작할 위치), M(개수) e.g. SELECT * FROM TABLE ORDER BY SCORE LIMIT 3

참고

Comments