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'
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Current Comments
2 comments so far (post your own) View All Comments Latest 10 Comments:Rose India is all implement are giving good.
Posted by Aravvind kuamr prasad on Saturday, 02.23.08 @ 15:58pm | #49663
what is the difference between dispatchActoin and LookupdispatchAction
Posted by raju on Tuesday, 09.18.07 @ 12:05pm | #27464