Selection: Retrieval of data from table by providing both col_name and row_name.

Where clause

• If is a clause which is used to filter the condition of rows

• It executes row by row.

• Syntax:

  Where col_name operrator values

Characteristics of where clause

1. It filters the condition row by row.
2. Here we can take multiple conditions.
3. We cant use multi row function condition.
4. Where clause filters null values

Path of execution

FROM

WHERE

SELECT

Functionality:

goes to the execution area, search for the column name and filter the condition row by row.