SQL Problem Solving: Merging Tables with Different Columns using UNION ALL | Step-by-Step Tutorial

Dive into the world of SQL problem-solving with our step-by-step tutorial. In this session, we tackle the challenge of merging two tables with varying column counts using UNION ALL. Explore the nuances of column aliases and understand their behavior across different SELECT statements. Whether you're refining your SQL skills or gearing up for interviews, this tutorial is designed for you.
📋 Problem Description:
We have two tables, "employee" and "employee_delhi," with different column counts. The objective is to merge these tables using UNION ALL and explore the behavior of column aliases in various SELECT statements.
Table creation & insertion script:
CREATE TABLE employee(
id INT,
name VARCHAR(500),
location VARCHAR(500)
);
CREATE TABLE employee_delhi(
id INT,
name VARCHAR(500)
);
INSERT INTO employee VALUES(1,'Suraj Yadav','Bengaluru'),
(2,'Yashoda Sharma','Chennai'),
(3,'Pawan Rathore','Nagpur');
INSERT INTO employee_delhi VALUES(56,'Utkarsh Kumar'),
(57,'Deepak Vaidya');
👉 Don't forget to like, share, and subscribe for more SQL tutorials and problem-solving sessions! Stay tuned for additional challenges in our SQL playlist.
#sql #interview #union

[@InnovativeBeautifulWorld]

Thanks a lot.

[@becomingbetterversion]

Glad you found it helpful! 😊

[@melissaleigh3013]

Perfect explanation thank you 🙏🏻

[@becomingbetterversion]

Thank you Melissa for your kind words 🙏

[@akshaygangwani9875]

how to save union data into a new table?

[@becomingbetterversion]

Hi Akshay,
We can do something like this -
SELECT * INTO new_table_name FROM
(
SELECT 1 AS id,'Kiran' AS name
UNION ALL
SELECT 2 AS id,'Shivam' AS name
) t1;