SQL Function Reference

String functions

CHAR CONCAT INSTR LEFT LENGTH LOCATE LOWER LPAD LTRIM REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SUBSTRING TRIM UPPER

Numeric functions

ABS CEILING COS EXP FLOOR GREATEST LEAST LOG MOD PI POW RAND ROUND SIGN SIN SQRT TAN TRUNCATE

Window functions

DENSE_RANK FIRST_VALUE LAG LAST_VALUE LEAD RANK ROW_NUMBER

Aggregate functions

AVG COUNT GROUP_CONCAT MAX MIN SUM

Regular expressions functions

REGEXP_INSTR REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR

Advanced functions

CAST COALESCE IF IFNULL ISNULL NULLIF WITH