• Home
  • About
    • PI photo

      PI

      Beginner's Blog

    • Learn More
    • Github
  • Posts
    • All Posts
    • All Tags
    • All Categories
  • Projects

[MySQL] 특정 개수의 값 출력

📆 Created: 2024.11.28 Thu

Reading time ~1 minute

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

참고

  • SQL 특정 개수의 값 출력


TILDATABASESQL Share Tweet +1
/#disqus_thread