Difference between having and group by?

AnswerBot
1y

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
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter