SQL AND Operator Explained with Examples | Learn SQL Step-by-Step

SQL TUTORIALS-

SQL AND Operator Statement

Introduction-

How to use AND operator in SQL with multiple conditions Explained with Examples

AND operator in SQL is used to combine two or more conditions in a WHERE clause. All conditions must be true for a row to be included in the result set...

✅ Example:- Select employees from IT department AND salary above 50000:

SELECT * FROM Employees
WHERE Department = 'IT' AND Salary > 10000;

✅Result Show :-

🔸 Example Table: Employees

✅ Example:- Employees in HR department AND city is Pune:-

✅SELECT Query :-

SELECT * FROM Employees
WHERE Department = 'HR' AND City = 'Pune';

✅Result Show :-

🔸 Example Table: Employees

✅ Example -IT employees in Pune with salary less than 10000:-

✅SELECT Query :-

SELECT * FROM Employees
WHERE Department = 'IT' AND City = 'Pune' AND Salary < 10000;

✅Result Show :-

🔸 Example Table: Employees

✅ Example -SQL Query Using AND and OR:-

✅SELECT Query :-

SELECT *
FROM Employees
WHERE Department = 'IT'
  AND (Salary > 9000 OR Name = 'POOJA');

✅Result Show :-

🔸 Example Table: Employees

May Be Like Important Link-

-Chart Of Account-OB13

-Define Plant-OX1

-Chart Of Account-OB13

-Define Financial Statement