FUNCTIONS

From SQLZOO
Jump to: navigation, search

SQL Functions

Standard SQL functions and some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.

ABSCURRENT_TIMESTAMPLENGTH+ INTERVALSUBSTRING(ansi)
AVGDATEPARTMAX+ (string)SUBSTRING
StringsDAYMINPOSITIONSUM
CASEDIVMINUTEQUARTERTAN
CASTEXTRACTMODRANKTO_CHAR(dates)
CEILFLOORMONTHREPLACETRIM
COALESCEHOURNULLIFRIGHTYEAR
CONCATIFNULLNVLROUND
COSINSTRPATINDEXSECOND
COUNTLEFT% MODULOSIN
CURRENT_DATELEN+(dates)SUBSTR
Language: English  • Deutsch
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense