SQL ANY and ALL Operators

SQL TUTORIALS-

SQL ANY and ALL Operators

Introduction-

✅In a Simple Word SQL, the ANY and ALL operators are used with comparison operators (like =, >, <, >=, <=, !=) to compare a value to a set of values returned by a subquery.Why this useful when comparing a single value to multiple values from another table or result set....

✅ Syntax Example SQL ANY Operator-

expression operator ANY (subquery)

✅ Syntax Example SQL ALL Operator-

expression operator ALL (subquery)

🔸 Example -)Table: Employee

🔸 Example -)Table: Department

✅ Example 1:-SQL ANY Operator-Test Find employees whose salary is greater than ANY salary in Department

SELECT * FROM EMPLOYEE
WHERE SALARY > ANY (
  SELECT SALARY FROM EMPLOYEE WHERE DEPT_ID = 1
);

✅Result Show :-

Result →

✅ Example 2: SQL ALL Operator-Test Find employees whose salary is greater than ALL salaries in Department 1-

SELECT * FROM EMPLOYEE
WHERE SALARY > ALL (
  SELECT SALARY FROM EMPLOYEE WHERE DEPT_ID = 1
);

✅Result Show :-

Result →

May Be Like Important Link-

-Credit Memo and Return PO

-Bill Of Material (BOM)

-How To Create Quotation

-How To Create Debit Memo Request