UNION & UNION ALL in SQL
UNION and UNION ALL both are used to display data from two or more tables. The difference between them is UNION filter duplicate data and UNION ALL presents all the data including duplicate data. Database- jai_school; Create two tables Insert some data India Table America Table UNION query example Output:- UNION ALL query example Output:-