SQL Where Query.

  • The SQL WHERE clause is used to filter the results obtained by the DML statements such as SELECT, UPDATE and DELETE.
  • Using the WHERE clause, data can be joined from a single table or multiple tables.
Syntax
        Select column1, column2,... columnN
        FROM table_name
        WHERE [condition];