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'
|

|