SQL Quiz

What SQL clause is used to filter rows based on a specified condition?

• a) GROUP BY

• b) HAVING

• c) WHERE

• d) LIKE

Which SQL clause is used to specify the number of rows to retrieve from a query result?

• a) ORDER BY

• b) GROUP BY

• c) LIMIT

• d) JOIN

Which SQL clause is used to sort the result set in ascending or descending order?

• a) HAVING

• b) ORDER BY

• c) GROUP BY

• d) LIKE

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

• a) WHERE

• b) JOIN

• c) IN

• d) LIMIT

Which SQL clause is used to filter rows based on a pattern match?

• a) HAVING

• b) GROUP BY

• c) LIKE

• d) ORDER BY

What SQL clause is used to specify conditions for grouping rows?

• a) GROUP BY

• b) WHERE

• c) IN

• d) JOIN

Which SQL clause is used to specify a condition for aggregated data after the GROUP BY clause?

• a) ORDER BY

• b) LIKE

• c) IN

• d) HAVING

Which SQL clause is used to filter rows from a table based on a list of values?

• a) JOIN

• b) WHERE

• c) IN

• d) LIMIT

What SQL clause is used to perform a partial match on a column's values?

• a) GROUP BY

• b) LIKE

• c) ORDER BY

• d) HAVING

Which SQL clause is used to filter rows based on a range of values?

• a) GROUP BY

• b) ORDER BY

• c) WHERE

• d) IN