What is the difference between WHERE and HAVING?

Question

can you help me with this question

in progress 0
Renuka 2025-02-22T05:54:08+00:00 1 Answer 8 views
0

Answer ( 1 )

  1. Aravind
    0
    2025-02-22T06:00:02+00:00
    Reply
    • WHERE is used to filter records before grouping (used with SELECT, UPDATE, DELETE).
    • HAVING is used to filter records after grouping (used with GROUP BY).

    📌 Example:

    SELECT department, COUNT(*)
    FROM employees
    WHERE salary > 50000
    GROUP BY department
    HAVING COUNT(*) > 10;

Leave an answer