Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLUNION vs UNION ALLSingle-choice MCQ

Two SELECTs are combined with `UNION ALL` and then `LIMIT 10` is applied at the end without any ORDER BY. What does the standard guarantee about which 10 rows you get?

SELECT id FROM a UNION ALL SELECT id FROM b LIMIT 10;