SQL Aggregate Functions
Aggregate SQL functions allow you to summarize the results of an expression for the group of rows (selected from a table, view, or table-valuated function) and returns a single value for that group.
SQL Functions
SQL String Functions
SQL string functions allow you to manipulate character data effectively. Here you can find almost common SQL string functions such as ASCII, CHR, CHAR, CONCAT, LENGTH or LEN, REPLACE, LOWER and UPPER.
SQL Mathematical Functions
Mathematical functions are very important to all programming languages and also to SQL. Here we cover all common SQL mathematical functions such as ABS, POWER, SQRT, RANDOM...with clear explanations and source code examples