Select Internal Functions in SQL

Key Words

• min
• max
• avg
• sum
• count

Select Statement Optional Functions

In the SELECT statement you can use the following built-in functions:

• COUNT number of records

Example:
SELECT COUNT(dmoes001.item)
FROM dmoes001

• AVG average value in column

Example:
SELECT AVG(dmoes001.spri)
FROM dmoes001

• SUM sum of the values in column

Example:
SELECT SUM(dmoes001.spri)
FROM dmoes001

• MAX maximum value in a column

Example:
SELECT MAX(dmoes001.spri)
FROM dmoes001

• MIN minimum value in a column

Example:
SELECT MIN(dmoes001.item)
FROM dmoes001

People who read this post also read :

Posted in: Enterprise tools,SQL in BAAN ERP