Parameters
- AVG
Computes the average of all non-NULL values for a numeric column.
- COU[NT]
Computes the total number of non-NULL values for a column.
- MAX[IMUM]
Computes the maximum value returned for a column. Applies to columns of type NUMBER, CHAR, VARCHAR2, NCHAR, and NVARCHAR2.
- MIN[IMUM]
Computes the minimum value returned for a column. Applies to columns of type NUMBER, CHAR, VARCHAR2, NCHAR, and NVARCHAR2.
- NUM[BER]
Performs a function similar to COUNT but computes the number of all values, including nulls.
- STD
Computes the standard deviation of all non-NULL values for a numeric column.
- SUM
Computes the sum of all non-NULL values for a numeric column.
- VAR[IANCE]
Computes the variance of all non-NULL values for a numeric column.
- LABEL
Allows you to specify a label for the computed value. If possible, this label will be printed to the left of the computed value.
- label_text
Text you want to use as a label when the computed value is printed.
- column_name
Name of the column you are summarizing. If it’s a computed column, the expression is the name. If your SELECT statement aliases the column, you must use that alias name here.
- group_column_name
Causes SQL*Plus to restart the calculation every time this column changes.
- ROW
Causes the computation to be performed once for each row returned by the query.
- REPORT
Causes the computation to be performed at the end of the report and to include values from all rows. REPORT is used for grand totals.