SUM

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

4D SQL Reference
- Functions
- - SQL Functions
  - ABS
  - ACOS
  - ASCII
  - ASIN
  - ATAN
  - ATAN2
  - AVG
  - BIT_LENGTH
  - CAST
  - CEILING
  - CHAR
  - CHAR_LENGTH
  - COALESCE
  - CONCAT
  - CONCATENATE
  - COS
  - COT
  - COUNT
  - CURDATE
  - CURRENT_DATE
  - CURRENT_TIME
  - CURRENT_TIMESTAMP
  - CURTIME
  - DATABASE_PATH
  - DATE_TO_CHAR
  - DAY
  - DAYNAME
  - DAYOFMONTH
  - DAYOFWEEK
  - DAYOFYEAR
  - DEGREES
  - EXP
  - EXTRACT
  - FLOOR
  - HOUR
  - INSERT
  - LEFT
  - LENGTH
  - LOCATE
  - LOG
  - LOG10
  - LOWER
  - LTRIM
  - MAX
  - MILLISECOND
  - MIN
  - MINUTE
  - MOD
  - MONTH
  - MONTHNAME
  - NULLIF
  - OCTET_LENGTH
  - PI
  - POSITION
  - POWER
  - QUARTER
  - RADIANS
  - RAND
  - REPEAT
  - REPLACE
  - RIGHT
  - ROUND
  - RTRIM
  - SECOND
  - SIGN
  - SIN
  - SPACE
  - SQRT
  - SUBSTRING
  - SUM
  - TAN
  - TRANSLATE
  - TRIM
  - TRUNC
  - TRUNCATE
  - UPPER
  - WEEK
  - YEAR

Home

4D v20 R7

4D SQL Reference

Functions

SUM



	Command SUMSUM ([ALL \|DISTINCT] arithmetic_expression)

Description

The SUM function returns the sum of the arithmetic_expression. The optional ALL and DISTINCT keywords are used to respectively retain or eliminate any duplicate values.

This example returns the sum of the expected sales less the sum of the actual sales, as well as the minimum and maximum value of the actual sales multiplied by 100 and divided by the expected sales for the SALES_PERSONS table:

SELECT MIN ( ( SALES * 100 ) / QUOTA ),
MAX ( ( SALES * 100 ) / QUOTA ),
SUM ( QUOTA ) - SUM ( SALES )
FROM SALES_PERSONS

SUM

Description

Example