UNION ALL and UNION
suggest changeSELECT 1,22,44 UNION SELECT 2,33,55
SELECT 1,22,44 UNION SELECT 2,33,55 UNION SELECT 2,33,55
The result is the same as above.
use UNION ALL
when
SELECT 1,22,44 UNION SELECT 2,33,55 UNION ALL SELECT 2,33,55
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents