Common SQL Functions

The database has many computation data with built-in functions. Aggregate Function SQL total SQL function returns a single value calculation from the value column. The SQL scalar function of the standard function returns a single value based on the input value. Useful tagging functions: UCASE ()-convert fields to uppercase LCASE ()-convert a field to lowercase min ()-extract character text field len ()-return length text field ROUND

The database has many computation data with built-in functions.

Aggregate Function SQL
The total SQL function returns a single value calculation from the value column.

Standard function SQL
The SQL scalar function returns a single value based on the input value.

Useful tagging functions:

UCASE ()-upper case of the conversion field
LCASE ()-converts a field to lowercase letters
Min ()-extract character text fields
Len ()-returned length text field
ROUND ()-rounds ROUND specific Decimals in a digital field
NOW ()-returns the current system date and time
Format ()-How to display fields
Tip: the total number of functions and responsibilities will be explained in detail in future chapters.

Useful Aggregate functions:

AVG ()-average returned value
Count ()-number of returned rows
First ()-returns the first value.
Last ()-returns the last value
Max ()-maximum returned value
Min ()-returns the smallest value
Total ()-total returned

The preceding SQL functions are commonly used, especially for beginners,