Group By
GROUP BY path ( COMMA path )*
The command GROUP BY is used to restrict the results to a single result per table. This command is useful in a variety of situations, such as when you are using aggregate functions. For example, the command select student, max(result.score) from Student as student, Examresult as result where student=result.student group by student returns a set of students and the corresponding java.lang.Integer value for each student's high score.
 |
