Pages

How to use SQL GROUP BY?

GROUP BY keyword is used to group rows according to given columns.

Example: Get average grade of each class students belong to.

SELECT studentClass, AVG(grade) FROM studentGrades GROUP BY
studentClass

No comments:

Post a Comment