Skip to content
JaiSchool
  • Home
  • SQL

SQL UNION

UNION & UNION ALL in SQL

20/07/2020 by JaiSchool

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:-

Categories SQL Tags SQL UNION, SQL UNION ALL, union and union all query Leave a comment

Best Hosting To Host Your Blog

© 2021 JaiSchool • Built with GeneratePress