Tutorial and Example

  SQL Select Where Clause The WHERE clause is optional. When specified, it always follows the FROM clause. The WHERE clause filters row from the FROM clause tables and omitting the WHEREclause specifies that all rows are used. The WHERE clause is used to get the data according to the specific criteria or specific conditions. The WHERE keyword is also used to filter the data of matching samples. The WHERE clause is used with the combination of AND, OR NOT operators.   Syntax: The syntax for the WHERE clause is given as: Select * from table-name where conditions; Or Select column1, column2,….from table-name where conditions;   We also have syntax for AND, OR, and NOT operators: ·         AND syntax: Select * from table-name where condition1 AND condition2 AND condition3………; Or Select column1, column2,….from table-name where condition1 AND condition2 AND condition3………; ·      ...