Asked in Saras Analytics
SQL: What is the difference between HAVING and WHERE? Can WHERE be replaced with HAVING?

AnswerBot
1y
HAVING is used with GROUP BY to filter grouped rows, WHERE is used to filter individual rows. WHERE cannot be replaced with HAVING.
WHERE is used to filter individual rows before grouping, HAVING is us...read more
Help your peers!
Add answer anonymously...
Interview Questions Asked to Senior Business Analyst at Other Companies
Top Skill-Based Questions for Saras Analytics Senior Business Analyst
Agile Methodology Interview Questions and Answers
250 Questions
SQL Interview Questions and Answers
250 Questions
Software Development Interview Questions and Answers
250 Questions
Machine Learning Interview Questions and Answers
250 Questions
Web Development Interview Questions and Answers
250 Questions
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

