Column Functions

LANSA

Column Functions
All about SELECT_SQLThe Things that Make Up this ExampleTo Execute this ExampleForms/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))




  • 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.
TypeNameCodeDescription
FunctionSET189NSET189NSELECT_SQL - SUM, AVG, COUNT, MAX, MIN
Form S_189FNS_189FNSELECT_SQL - SUM, AVG, COUNT, MAX, MIN