Podcast
Questions and Answers
What does INNER JOIN do?
What does INNER JOIN do?
- Return every row in joined tables
- Filter databases to return only columns that exist in every table
- Combine tables and save them as a new table
- Compare tables and return only the rows that have a matching value in a specified column (correct)
What is the primary function of INNER JOIN?
What is the primary function of INNER JOIN?
- Combine tables and save them as a new table
- Return every row in joined tables
- Compare tables and return only the rows that have a matching value in a specified column (correct)
- Filter databases to return only columns that exist in every table
When using INNER JOIN, what happens to rows without matching values?
When using INNER JOIN, what happens to rows without matching values?
- They are combined and saved as a new table
- They are returned along with matching rows
- They are compared to return only the unique rows
- They are filtered out and not included in the result (correct)
Which query will return every name that starts with the prefix 'Dr.'?
Which query will return every name that starts with the prefix 'Dr.'?