CGI Interview Question
Give me an example of a left join in SQL
Interview Answer
Anonymous
Jun 11, 2024
SELECT Departments.DepartmentName, Employees.Name FROM Departments LEFT JOIN Employees ON Departments.DepartmentID = Employees.DepartmentID;
Give me an example of a left join in SQL
Anonymous
SELECT Departments.DepartmentName, Employees.Name FROM Departments LEFT JOIN Employees ON Departments.DepartmentID = Employees.DepartmentID;
Check out your Company Bowl for anonymous work chats.