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

SQL NOT Operator

SQL TUTORIALS-

SQL NOT Operator Statement

Introduction-

Trulli Trulli

-🔍SQL NOT Operator – Explanation with Example (For learntosap.com)

NOT operator in SQL is used to negate a condition in a WHERE clause. It returns the rows for which the condition is false.....

Emoji Examples in HTML

🔸 Example Table: Employees

ID Name Department Salary
1 ANNI IT 10000
2 POOJA IT 9000
3 RAJ SALES 5000

✅ Example 1: NOT Equal (!=):-


SELECT * FROM Employees
WHERE NOT Department = 'IT';

✅Result Show :-

Emoji Examples in HTML

🔸 Example Table: Employees

ID Name Department Salary
3 RAJ SALES 5000

✅ Example 2: NOT IN:-

✅SELECT Query :- 


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

✅Result Show :-

Emoji Examples in HTML

🔸 Example Table: Employees

ID Name Department Salary
2 Pooja IT 9000

✅ Example 3: NOT BETWEEN:-

✅SELECT Query :- 


SELECT * FROM Employees
WHERE Salary NOT BETWEEN 8000 AND 4000;

✅Result Show :-

Emoji Examples in HTML

🔸 Example Table: Employees

ID Name Department Salary
1 ANNI IT 10000
3 RAJ IT 5000

May Be Like Important Link-

-Chart Of Account-OB13

-Define Plant-OX1

-Chart Of Account-OB13

-Define Financial Statement