WHERE Clause in SQL

sqlIn SQL, you can fetch, update, and delete records in a table when a certain condition is met.  For this reason, we use WHERE clause. The most commonly used operators with WHERE clause are given below.

  • Equal (=)
  • Not Equal (<> or !=)
  • Greater than (>)
  • Less than (<)
  • Greater than or Equal (>=)
  • Less than or Equal (<=)

The syntax for WHERE clause is given below.

SELECT * FROM {Table_Name} WHERE {Column_Name} = {Column_Value}