SQL JOIN, Order By, Group By

Which SQL command is used to retrieve data from multiple tables based on a related column between them?

• SELECT

• JOIN

• GROUP BY

• ORDER BY

What does the SQL GROUP BY clause do?

• Sorts the result set in ascending order

• Combines rows with the same values into summary rows

• Filters rows based on a specified condition

• Joins two or more tables

Which SQL command is used to sort the result set in descending order?

• ASC

• DESC

• SORT

• ORDER BY

To retrieve data from a table named "customers" where the "name" column contains the word "John," you would use which SQL clause?

• LIKE

• WHERE

• MATCH

• SELECT

What does the SQL LIKE clause allow you to do?

• Group similar values in a column

• Join multiple tables

• Search for a specified pattern in a column

• Sort data in ascending order

Which SQL clause is used to filter the result set for a specific condition?

• WHERE

• HAVING

• GROUP BY

• JOIN

Which SQL command is used to retrieve all columns from a table named "orders"?

• GET ALL

• SELECT *

• RETRIEVE

• FETCH

What does the SQL ORDER BY clause do?

• Groups similar values in a column

• Filters rows based on a specified condition

• Sorts the result set based on one or more columns

• Combines rows with the same values into summary rows

Which SQL clause is used to apply a condition to the result set after the GROUP BY clause has been applied?

• WHERE

• HAVING

• FILTER

• ORDER BY

What is the purpose of an SQL JOIN?

• To group data in a table

• To retrieve data from multiple tables based on related columns

• To sort the result set

• To filter rows based on a condition