28.2.4 Calculations
- Built-in functions:
COUNT SUM AVG
MAX MIN
- E.g.,
SELECT COUNT(*) FROM Customer WHERE State = 'CA'
- The * argument applies to entire record; only valid in
COUNT
- Specify column for other functions:
SELECT AVG(Unit_Price) FROM Product
prev
|top
|next