Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Quartz THE key Word WHERE in SQL, SQL Tutorial

Related Tutorials


Share on Google+Share on Google+

THE key Word WHERE in SQL, SQL Tutorial

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.







SELECT column FROM table
WHERE column operator value

 The following operators can be used:

Operator Description
= Equal
BETWEEN Between an inclusive range

Search for a pattern

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


 we add a WHERE  to the SELECT statement: 

WHERE unit='india'



If you enjoyed this post then why not add us on Google+? Add us to your Circles

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

Related Tutorials

Discuss: THE key Word WHERE in SQL, SQL Tutorial  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image