You can list more than one expression in the GROUP BY clause—that is, you can group a table by any combination of expressions.
The following query lists the average price of products, grouped first by name and then by size:
SELECT Name, Size, AVG( UnitPrice ) FROM Products GROUP BY Name, Size; |
Name | Size | AVG(Products.UnitPrice) |
---|---|---|
Baseball Cap | One size fits all | 9.5 |
Sweatshirt | Large | 24 |
Tee Shirt | Large | 14 |
Tee Shirt | One size fits all | 14 |
... | ... | ... |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |