What is the difference between the HAVING and GROUP BY clauses?
AnswerBot
2y
HAVING is used to filter groups while GROUP BY is used to group rows based on a column.
HAVING is used with GROUP BY to filter groups based on a condition
GROUP BY is used to group rows based on a colum...read more
veena b
2y
Having: Aggregate the data and then filter the result.
Group By: This clause is used to group the results by one or more columns used group by.
Help your peers!
Add answer anonymously...
TCS Plsql Developer interview questions & answers
A Plsql Developer was asked 4mo agoQ. What is the difference between procedures and functions?
A Plsql Developer was asked 4mo agoQ. What is the difference between char, varchar, and varchar2 data types?
A Plsql Developer was asked 4mo agoQ. What are the differences between Rank and Dense Rank in SQL?
Popular interview questions of Plsql Developer
A Plsql Developer was asked 4mo agoQ1. What is the difference between procedures and functions?
A Plsql Developer was asked 4mo agoQ2. What is the difference between char, varchar, and varchar2 data types?
A Plsql Developer was asked 4mo agoQ3. What are the differences between Rank and Dense Rank in SQL?
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
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
Follow Us
