SUM

Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter 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

Siehe auch

AVG
COUNT

Vorige Seite

Nächste Seite

EIGENSCHAFTEN

Produkt: 4D
Thema: Functions

SEITENINHALT

Description

Beispiel

GESCHICHTE

ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v20 R7)

Fehler melden