Column Functions
| All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/Components for this Example |
Function SET189N or form S_189FN
You can use aggregate functions to summarize the results of a query rather than listing all of the rows:
SELECT_SQL FIELDS((#SALARY 'AVG(SALARY)')) FROM_FILES((PSLMST))
You can use aggregate functions to summarize the results of a query rather than listing all of the rows:
SELECT_SQL FIELDS((#SALARY 'AVG(SALARY)')) FROM_FILES((PSLMST))
- SUM () gives the total of all the rows, satisfying any conditions, of the given column, where the given column is numeric.
- AVG () gives the average of the given column.
- MAX () gives the largest figure in the given column.
- MIN () gives the smallest figure in the given column.
- COUNT(*) gives the number of rows satisfying the conditions.
| Type | Name | Code | Description |
| Function | SET189N | SET189N | SELECT_SQL - SUM, AVG, COUNT, MAX, MIN |
| Form | S_189FN | S_189FN | SELECT_SQL - SUM, AVG, COUNT, MAX, MIN |