Where Clause in SQL Server

Описание: SQL WHERE Clause :
The Where Clause is used to filters records .
It is used to extract only those records that fullfill a specified condition.
Syntax :
SELECT Column1, Column2,……
FROM table – name
WHERE Condition ;
Note : The Where Clause is not only used in SELECT Statement, it is also used in UPDATE, DELETE , etc.