Netezza Aggregate Function | Notes |
AVG | Not supported: • AVG (BOOLEAN) • AVG (BOOLEAN) DISTINCT • AVG (NCHAR) • AVG (NCHAR) DISTINCT • AVG (NVARCHAR) • AVG (NVARCHAR) DISTINCT |
COUNT | |
MAX | Not supported: • MAX (BOOLEAN) • MAX (BOOLEAN) DISTINCT • MAX (NCHAR) • MAX (NCHAR) DISTINCT • MAX (NVARCHAR) • MAX (NVARCHAR) DISTINCT In version 6.0: analytic, with the same arguments not supported. MAX(NULL) analytic is NULL. |
MIN | Not supported: • MIN (BOOLEAN) • MIN (BOOLEAN) DISTINCT • MIN (NCHAR) • MIN (NCHAR) DISTINCT • MIN (NVARCHAR) • MIN (NVARCHAR) DISTINCT |
SUM | Not supported: • SUM (BOOLEAN) • SUM (BOOLEAN).DISTINCT • SUM (NCHAR) • SUM (NCHAR).DISTINCT • SUM (NVARCHAR) • SUM (NVARCHAR).DISTINCT |