picoSQL - Language reference manual
picoSQL - Language reference manual |
|
|
COUNT ([DISTINCT] column-name) |
Return the number of rows in each group. If the DISTINCT column-name clause is specified, the function return the number of different values in the specified column. |
|
MIN(column-name) |
Return the minimum value found in the specified column of each group. |
|
MAX(column-name) |
Return the maximum value found in the specified column of each group. |
|
SUM(column-name) |
Return the total of the columns for each group. The specified column type must be numeric. |
|
AVG(column-name) |
Return the average of the columns for each group. The specified column type must be numeric. |
NOTE: picoSQL do not allow to use an aggregate function in an arithmetic expression.