WHERE versus HAVING
QuizEasy-MediumAsked in: TCS
What is the difference between WHERE and HAVING?
- WHERE filters rows before grouping; HAVING filters groups after the aggregates are computed
- WHERE filters groups; HAVING filters rows
- They are the same and can always be swapped
- HAVING can be used only without GROUP BY
This question is part of Pro+
Pro+ opens every question in Interview Prep and the mock interview. Every article and the first 2 questions of each topic stay free. Hands-on Selenium and API tasks follow their course lesson's own lock.