SQL in Telugu - How To Use Union & Union All Operators In SQL | SQL Tutorial

Hello,
In this video you can Learn how to use UNION and UNION ALL Operators in SQL with easy to follow examples. This tutorial explains easy to understand examples, keep practicing.
#sql #sqlinterviewquestions #sqltelugu #telugutechcoder
-- Create employees table
CREATE TABLE employees (
id INT,
name VARCHAR(100),
role VARCHAR(50)
);

-- Create contractors table
CREATE TABLE contractors (
id INT,
name VARCHAR(100),
role VARCHAR(50)
);

-- Create interns table
CREATE TABLE interns (
id INT,
name VARCHAR(100),
role VARCHAR(50)
);

-- Insert data into employees table
INSERT INTO employees (id, name, role)
VALUES
(1, 'Alice', 'Employee'),
(2, 'Bob', 'Employee'),
(3, 'Charlie', 'Employee'),
(4, 'David', 'Employee'),
(5, 'Eva', 'Employee'),
(3, 'Charlie', 'Employee');



-- Insert data into contractors table
INSERT INTO contractors (id, name, role)
VALUES
(101, 'Eva', 'Contractor'),
(102, 'Frank', 'Contractor'),
(103, 'Gavin', 'Contractor'),
(104, 'Isabella', 'Contractor');

-- Insert data into interns table
INSERT INTO interns (id, name, role)
VALUES
(201, 'Grace', 'Intern'),
(202, 'Helen', 'Intern'),
(203, 'Jack', 'Intern'),
(204, 'Lily', 'Intern');

Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
Subscribe Now and Stay Updated! 🔔