Which SQL clause is used to filter records based on a specified condition?

Options

  • A. ORDER BY
  • B. GROUP BY
  • C. WHERE
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. WHERE

Detailed Explanation

  • WHERE clause filters rows according to a specified condition.
  • It can be used with SELECT, UPDATE and DELETE statements.
  • Example: SELECT * FROM students WHERE age > 18;