Maximum no of records by INNER JOIN,LEFT JOIN,RIGHT JOIN & FULL JOIN
--Maximum no of records by INNER JOIN,LEFT JOIN,RIGHT JOIN & FULL JOIN --SQL INTREVIEW QUESTION --Asked by Synchron ---------------------------------------------------------------------------------- USE [SSIS] Create table Synechron_TABL ( ID int , DepartmentName nvarchar(50), Location nvarchar(50), DepartmentHead nvarchar(50) ) Go --DROP TABLE Synechron_TABL Insert into Synechron_TABL values (1, 'IT', 'London', 'Rick') Insert into Synechron_TABL values (1, 'Payroll', 'Delhi', 'Ron') Insert into Synechron_TABL values (1, 'HR', 'New York', 'Christie') Insert into Synechron_TABL values (1, 'Other Department', 'Sydney', 'Cindrella') Go --DROP TABLE Synechron_TABL_2 Create table Synechron_TABL_2 ( ID int , Name nvarchar(50), Gender nvarchar(50), Salary int ) Go Insert into Synechron_TABL_2 values (1, 'T...