SQL Basics | Functions

In databases, much of the data is represented as numbers, and functions are used for numeric operations. For example, they can calculate the sum of those numbers or compute an average.

• AVG
• COUNT
• MAX
• MIN
• SUM

Function syntax

Functions are used as follows.

SELECT "function_name"("field_name")
FROM "table_name";