Which SQL keyword is used to combine rows from two or more tables based on a related column between them?

JOIN

SELECT

WHERE

GROUP BY

Which type of JOIN returns only the rows that have matching values in both tables being joined?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

Which type of JOIN returns all the rows from the left table and the matched rows from the right table?

LEFT JOIN

INNER JOIN

RIGHT JOIN

FULL OUTER JOIN

Which type of JOIN returns all the rows from the right table and the matched rows from the left table?

RIGHT JOIN

INNER JOIN

LEFT JOIN

FULL OUTER JOIN

INNER JOIN

LEFT JOIN

RIGHT JOIN

Which SQL keyword is used to combine the result sets of two or more SELECT statements into a single result set?

UNION

JOIN

GROUP BY

WHERE

Which SQL keyword is used to combine the result sets of two or more SELECT statements and includes duplicate rows in the final result set?

UNION ALL

UNION

JOIN

GROUP BY

Which SQL keyword is used to retrieve only the distinct (unique) values from a single column in a table?

DISTINCT

UNIQUE

SELECT

WHERE

Which SQL keyword is used to combine the result sets of two or more SELECT statements and returns only the rows that appear in both result sets?

INTERSECT

UNION

JOIN

GROUP BY

Which SQL keyword is used to combine the result sets of two or more SELECT statements and returns all the rows from the first result set that are not present in the second result set?

EXCEPT

UNION

JOIN

GROUP BY

More Quizzes