SQL – Where Clause
Table Of Contents:
- What Is SQL Where Clause?
- Syntax Of Where Clause.
- Examples Of Where Clause.
- Where Clause Operations.
(1) What Is SQL Where Clause ?
- Where clause is used to select the specific records for you.
- It will only display the records you want to see.
(2) Syntax Of Where Clause ?
SELECT column1, column2, ...
FROM table_name
WHERE condition;
(3) Examples Of Where Clause ?
Demo Data:
![](https://www.praudyog.com/wp-content/uploads/2023/04/11-1024x390.jpg)
Example-1:
SELECT * FROM Customers
WHERE Country='Mexico';
![](https://www.praudyog.com/wp-content/uploads/2023/04/23-1024x260.jpg)
Example-2:
SELECT * FROM Customers
WHERE CustomerID=1;
![](https://www.praudyog.com/wp-content/uploads/2023/04/24-1024x148.jpg)
(4) Where Clause Operations?
![](https://www.praudyog.com/wp-content/uploads/2023/04/25-1024x544.jpg)
Example-3:
SELECT * FROM Products
WHERE Price = 18;
![](https://www.praudyog.com/wp-content/uploads/2023/04/26-1024x238.jpg)
Example-4:
SELECT * FROM Products
WHERE Price BETWEEN 50 AND 60;
![](https://www.praudyog.com/wp-content/uploads/2023/04/27-1024x165.jpg)
Example-5:
SELECT * FROM Customers
WHERE City LIKE 's%';
![](https://www.praudyog.com/wp-content/uploads/2023/04/28-1024x221.jpg)