WHERE Statement in SQL

WHERE clause is used with the SELECT keyword.

WHERE Statement in SQL

WHERE Clause in SQL 

     

WHERE clause is used with the SELECT keyword. ' Where' is a clause which is used for searching the data with a particular condition.  

If the data in the table matches condition then it returns the specific value of that particular data.

Syntax

 

 

 

 

 

SELECT column FROM table
WHERE column operator value

 The following operators can be used:

Operator Description
= Equal
BETWEEN Between an inclusive range
LIKE

Search for a pattern

IN If you know the exact value you want to return for at least one of the columns

WHERE in SQL:

 we add a WHERE  to the SELECT statement: 

SELECT * FROM Persons
WHERE unit='india'