Difference between revisions of "FUNCTIONS"

From SQLZOO
Jump to: navigation, search
Line 1: Line 1:
 
<h3>SQL Functions</h3>
 
<h3>SQL Functions</h3>
−
Standard SQL functions together with some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.
+
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.
 
<table>
 
<table>
 
<tr><th></th><th></th><th></th><th></th></tr>
 
<tr><th></th><th></th><th></th><th></th></tr>

Revision as of 11:09, 10 August 2012

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
Retrieved from "http://sqlzoo.net/w/index.php?title=FUNCTIONS&oldid=3429"