How To Append Tables in SQL | Tutorial For Beginners

Namastey All,

Welcome to Select Star. This video aims to explain and simplify SET operators in SQL that is UNION, UNION ALL, INTERSECT, EXCEPT (MINUS)

Topics covered :

1. UNION clause : Append two or more tables giving distinct rows in result
2. UNION ALL : Append two or more tables
3. ITERSECT : Returns whatever is common between two tables
4. EXCEPT (or MINUS) : Returns whatever is in forst table except coomon rows between the two tables.
5. CAST function : Used to convert datatype of a column
6. Difference between UNION and UNION ALL
7. Number of rows after applying joins?

Script for table creation :

create table gold (id int, medal varchar);

insert into gold values
(1, 'GOLD'),(2, 'GOLD'),(3, 'GOLD'),(4, 'GOLD'),(5, 'GOLD');

select * from gold;

create table silver (id varchar, silver varchar);

insert into silver values (2,'SILVER'),(3, 'SILVER'),(101, 'SILVER'),(201, 'SILVER'),(301, 'SILVER'),(401, 'SILVER'),(501, 'SILVER');

select * from silver;

Frequently asked question about joins in an interview :

Other questions :

Related Playlists:

1. Basic SQL Course :

2. SQL Easy Interview Questions :

3. SQL Mediun to Hard Level Interview Questions :

Happy Querying

#sql #data #dataanalytics #dataanalyst #analysis #analyst #dataengineers #dataengineering #machinelearning #datascience #datascientist #machinelearningengineer #businessanalyst #businessanalyticsjobs #businessanalytics #sqlserver #sqltips #sqlforbeginners #postgres #postgresql #mssqlserver #mssql #oracle #mysql #mysqltutorials #database #databasedesign #databasemanagement