The WHERE Clause is used when you want to retrieve specific information from a table excluding other irrelevant data. Table name is the place holder for the name of the table, and condition is the place holder for the where clause. Not only is the where clause optional, but the where clause can contain multiple conditions by using the AND keyword.
Syntax:
SELECT col1, col2... FROM table_ name WHERE search_condition;
