Loading the lesson
Loading the lesson
Search AllRounder.ai
Search the courses, subjects, tracks, games and features, or jump straight to a page.
Search the courses, subjects, tracks, games and features, or jump straight to a page.
2 cards from this section. Quick, good the night before a test.
What does INNER JOIN do?
Think about how it works with overlapping data.
What is a LEFT JOIN?
What happens to non-matched records?
What does an INNER JOIN do?
Consider what it means for records to match.
True or False: A LEFT JOIN will return only matching records from the left table.
Think about the nature of all records being included.
Create a dataset of students and classes. Write a SQL query that lists all students and their classes, including students who are not enrolled in any classes.
Think of how you can keep all students in the results.
You have two tables: Employees and Projects. Use a FULL OUTER JOIN to find all employees and their projects, showing employees without projects and projects without employees.
Consider how to capture every employee and project, regardless of their pairing.
5 more questions in this section. Enroll free to practise them all.
Enroll free