The LIMIT Keyword
- The
LIMIT
keyword can be used for limiting the number of rows that are fetched as a result of aSELECT
statement; - The
LIMIT
keyword always comes after theORDER BY
clause;
12345SELECT * FROM students WHERE age < 20 ORDER BY enrollment_date LIMIT 1;
Everything was clear?
Thanks for your feedback!
SectionΒ 3. ChapterΒ 8
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Suggested prompts:
Ask me questions about this topic
Summarize this chapter
Show real-world examples
Awesome!
Completion rate improved to 1.72
The LIMIT Keyword
Swipe to show menu
- The
LIMIT
keyword can be used for limiting the number of rows that are fetched as a result of aSELECT
statement; - The
LIMIT
keyword always comes after theORDER BY
clause;
12345SELECT * FROM students WHERE age < 20 ORDER BY enrollment_date LIMIT 1;
Everything was clear?
Thanks for your feedback!
SectionΒ 3. ChapterΒ 8