"if you encounter any errors in SAP, send me a screenshot at pramod@learntosap.com, and I will help you resolve the issue."

SQL WHERE clause Statement

SQL TUTORIALS-

SQL WHERE clause Statement

Introduction-

Trulli Trulli

🔍 What is the WHERE Clause?✅WHERE clause in SQL is used to filter records. commonly used in SELECT, UPDATE, DELETE, and INSERT statements to limit the data affected by the query. The condition can include operators like =, >, <, BETWEEN, LIKE, IN, IS NULL, and logical operators like AND, OR, NOT.

✅ Basic Example1:-Select customers from USA


SELECT *  
FROM Customers  
WHERE Country = 'USA';

✅Result Show :-

Emoji Examples in HTML

Customers

CustomerID Name Country
1 ANNI USA
2 SUJAN USA
3 BOULT USA

✅ Example:- Select orders made in 2025:-

✅SELECT Query :- 


SELECT ProductName, Price  
FROM Products  
WHERE Price > 50;

✅Result Show :-

Emoji Examples in HTML

Products

ProductName Price
Laptop 90000
Mobile 70000

✅ Example -Select employees from "Sales" department:-

✅SELECT Query :- 


SELECT Name, Department  
FROM Employees  
WHERE Department = 'IT';

✅Result Show :-

Emoji Examples in HTML

Employees

Name Department
Pramod IT
Pooja IT
Rajesh IT
Rupesh IT

✅ Example 4: Select orders made in 2025:-

✅SELECT Query :- 


SELECT *  
FROM Orders  
WHERE OrderDate BETWEEN '2025-02-01' AND '2025-11-30';

✅ Example -SELECT DISTINCT job titles from an Employees table:-

✅SELECT Query :- 

SELECT DISTINCT Name, Department FROM Employees;

✅Example -Employees hired after 2025-

✅SELECT Query :- 


SELECT *
FROM Employees
WHERE HireDate > '2025-01-01';

May Be Like Important Link-

-Chart Of Account-OB13

-Define Plant-OX1

-Chart Of Account-OB13

-Define Financial Statement