Executing SQL LIMIT Without ORDER BY in MySQL 8 4
You run:
SELECT * FROM employees LIMIT 5;
What’s the problem here?
A. Syntax error
B. Returns random/unpredictable rows without ORDER BY
C. LIMIT is slow
D. LIMIT works only in MySQL
💬 Do you always use ORDER BY with LIMIT?
0:39 1. Let's verify this on the official MySQL website to see if we can confirm whether the information shown in the image is accurate.
1:55 2. Let's test it out.
3:54 3.In SQL, when the LIMIT clause is used without specifying an ORDER BY clause, are the results displayed in ascending order by default? Let's test this in a different way.
5:38 4.What happens if the table contains a primary key?