Question

In SQL, what is the difference between 'WHERE' and 'HAVING' clauses?

Q: Answer-In SQL, what is the difference between 'WHERE' and 'HAVING' clauses?

WHERE applies to individual rows before GROUP BY processing and cannot use aggregate functions. HAVING applies after GROUP BY to filter entire groups and can use aggregate functions. Example in banking SELECT BranchID, COUNT AS TotalAccounts FROM Accounts WHERE StatusActive GROUP BY BranchID HAVING COUNT 500 this first filters only active accounts WHERE, groups by branch, then shows only branches with more than 500 active accounts HAVING.