You can specify a GROUP BY
or HAVING
clause for aggregation.
Use a GROUP BY
clause to group rows based on the value of one or more expressions. A GROUP BY
clause groups rows but does not guarantee the order of the result set.
Specify a GROUP BY
clause in one of the following ways:
Use a HAVING
clause to restrict the groups of rows to those groups for which a specified condition is TRUE.
Specify a HAVING
clause in one of the following ways:
Click Next to continue.
Copyright © 2006, 2008, Oracle. All rights reserved.