THE key Word WHERE in SQL, SQL Tutorial
Posted on: April 18, 2011 at 12:00 AM
Posted on: April 18, 2011 at 12:00 AM
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' |
- Quartz Tutorial
- Advance (Enterprise) Features
- Aggregate Functions in SQL, SQL Tutorial
- Backup File With Separator
- Backup Into txt File
- Backup selected records into txt file
- Call Procedure
- Close Cursors in SQL
- Configuration, Resource Usage and StdSchedulerFactory
- Create After Insert Trigger in SQL
- Create Before Insert Trigger in SQL
- Create Before Update Trigger in SQL
- Create Delete Trigger in SQL
- Create a Simple Procedure
- Create After Update Trigger in SQL
- Create Database in SQL,SQL Tutorial
- Creating Cursors in SQL
- More About the CronTrigger
- Declare Cursors in SQL
- The DELETE Statement, SQL Tutorial
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
Ask Questions? Discuss: THE key Word WHERE in SQL, SQL Tutorial
Post your Comment