Question

Which is most suitable scenario for the use of group by clause?

Answer 1

Hello!

• The GROUP BY clause is a SQL command that is used to group rows that have the same values.

• The GROUP BY clause is used in the SELECT statement

• Optionally it is used in conjunction with aggregate functions to produce summary reports from the database

Thanks!!