Home Quartz THE key Word WHERE in SQL, SQL Tutorial
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

THE key Word WHERE in SQL, SQL Tutorial

Advertisement
This page discusses - THE key Word WHERE in SQL, SQL Tutorial

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'

 

Advertisements

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 18, 2011

Ask Questions?    Discuss: THE key Word WHERE in SQL, SQL Tutorial  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com