SQL Interview Question 2025 | Total Records from INNER, LEFT, RIGHT, FULL and CROSS JOIN

Details

Description

In this video, I have discussed how to solve the SQL Interview Questions:
Q. Determine the total number of records obtained from table1 and table2 after performing INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, and CROSS JOIN based on the ID column.

-- Create Table1
CREATE TABLE table1 (
ID INTEGER
);

-- Insert values into Table1
INSERT INTO table1 (ID) VALUES
(1), (1), (1), (2), (2), (3), (4), (NULL), (NULL);

-- Create Table2
CREATE TABLE table2 (
id INTEGER
);

-- Insert values into Table2
INSERT INTO table2 (id) VALUES
(1), (1), (1), (2), (2), (3), (NULL);

SQL Interview QnAs: https://www.youtube.com/playlist?list=PLL871c9yfLoimvglCSz6UQoqLJcFBJGKo

#sql #postgresql #deloitte #deloittejobs #mysql #interview #dataengineering #dataanalytics #dataanalysis #capgemini #deloitte #deloittejobs #capgeminihiring #kpmg