SQL;

WHERE CLAUSE IN SQL

Where Clause is used to specify the records that statisfied the given condition, like fetch only those students records which have more than 70% marks.
The Where Clause is not used in the select statement, but it work in the UPDATE,DELETE statement etc.

When use where clause ?

• It Delete only specific rows.
• It retrive only specific record.
• It update only specific record.

 SELECT column1, column2,column3.. columnN 
FROM table_name
WHERE [condition]
	

Condition Example:

DELETE FROM Employee
WHERE salary<30000;