LIMIT rows returned

Question

LIMIT rows returned

Accepted Answer

LIMIT N restricts the result to at most N rows. Without ORDER BY, the database may return any N rows - in practice most engines return the first N in storage order. Here the result is Alice and Bob. Always pair LIMIT with ORDER BY when you need a predictable subset.

id	name	salary
1	Alice	90000
2	Bob	75000
3	Carol	82000