Where Clause in SQL
The Where clause in SQL query is used with the
SELECT keyword.' Where' clause search the data with a particular condition. In
case the data matches with condition, return you the specific value of
particular data value.
Syntax
SELECT column FROM table WHERE column operator value
|
The Select is used to retrieve the record from a
table.
column : This specify the name of the column, which
you want to retrieve from table.
From : The From Keyword specify the name of the
table from where data is retrieved.
table :This specify the name of the table.
Where column : The clause where search
the data with a particular condition. If data matches with the condition ,return
you the specific value of data.
The List of Operator can be used as
| 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 |
Understand with Example
The Tutorial illustrate an example from where clause in
SQL. In this Tutorial we use a select query to retrieve the record from
table 'country'.
The select query return you the records or rows from
table country. In case the data matches with the specified condition, return you
the specific value of record.
Output of the above query is
The select query used with where clause, which
search the data with a particular condition.
| select * from country where countryname='India'; |
Output of the above query is
Download Source
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
