What is the use of group by and having? Write sample query using those ?

AnswerBot
1y

Group by and having are used to group data and filter groups based on conditions.

  • Group by is used to group data based on a specific column or expression.

  • Having is used to filter groups based on condit...read more

abid shaikh
1y

we are use group by and having to perform the aggregate operation on data and filter the result on applying condition . The GROUP BY is use to group the rows having same values in one or more columns ...read more

Help your peers!
Add answer anonymously...
Nalashaa Solutions PHP 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