| Oracle PL / SQL » Select Query » GROUP BY |
| 1. | Use avg, sum, max and count functions with group | ||
| 2. | Using the GROUP BY Clause | ||
| 3. | Must include a nonaggregate column in the SELECT list in the GROUP BY clause | ||
| 4. | Use group by and avg | ||
| 5. | GROUP BY may be used on a column without the column name appearing in the result set | ||
| 6. | Grouping at Multiple Levels: group by more than one column | ||
| 7. | Column sequence in the group by impacts the ordering | ||
| 8. | Using the ORDER BY Clause to Sort Groups | ||
| 9. | You don't have to include the columns used in the GROUP BY clause in your SELECT clause | ||
| 10. | GROUP BY and HAVING clauses | ||
| 11. | Using a Column Multiple Times in a GROUP BY Clause | ||
| 12. | timing and auto tracing a select statement with group |