WHERE clauses sieve various queries like SELECT, UPDATE, DELETE, and INSERT. They represent criteria used to determine activity. They are visible after a table name, and their condition follows. The WHERE clause equally crucial like statements.

Qualities of the WHERE clause –

  • It is an alternative.
  • It enables any condition to be specified.
  • It provides the specification of various conditions.
  • It's a Case sensitivity only applies to statements using LIKE comparisons.
BY Best Interview Question ON 13 Jan 2019