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

SQL IN Operator

SQL TUTORIALS-

SQL IN Operator

Introduction-

-✅IN operator allows you to specify multiple values in a WHERE clause.It is a shorthand for multiple OR conditions.

Emoji Examples in HTML

ID	Name	CITY	DEPARTMENT
1	ANNI	PUNE	IT
2	SUJAN	MUMBAI	HR
3	BOULT	DELHI	IT



SELECT * FROM Employees
WHERE City IN ('Mumbai', 'Pune');

✅Result Show :-

Result → ANNI | SUJAN |



SELECT * FROM Employees
WHERE EmployeeID IN (1, 3);

✅Result Show :-

Result → SUJAN | BOULT |



SELECT * FROM Employees
WHERE Name IN ('Anni', 'Boult');

✅Result Show :-

Result → ANNI |BOULT |



SELECT * FROM Employees
WHERE Department NOT IN ('Sales', 'Finance');

✅Result Show :-

Result → ANNI | SUJAN | BOULT |