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

Options

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

Correct Answer (Detailed Explanation is Below)

B. WHERE

Detailed Explanation

  • WHERE: Filters rows according to a specified condition.
  • It can be used with SELECT, UPDATE and DELETE statements.
  • Example: SELECT * FROM students WHERE marks > 60;