Difference between revisions of "FUNCTIONS"

From SQLZOO
Jump to: navigation, search
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{Functions ref}}
 
<h3>SQL Functions</h3>
 
<h3>SQL Functions</h3>
 
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.
 
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.
Line 14: Line 15:
 
<tr><td align='left'>[[COUNT]]</td><td align='left'>[[LEFT]]</td><td align='left'>[[% MODULO]]</td><td align='left'>[[SIN]]</td><td></td></tr>
 
<tr><td align='left'>[[COUNT]]</td><td align='left'>[[LEFT]]</td><td align='left'>[[% MODULO]]</td><td align='left'>[[SIN]]</td><td></td></tr>
 
<tr><td align='left'>[[CURRENT_DATE]]</td><td align='left'>[[LEN]]</td><td align='left'>[[+(dates)]]</td><td align='left'>[[SUBSTR]]</td><td></td></tr>
 
<tr><td align='left'>[[CURRENT_DATE]]</td><td align='left'>[[LEN]]</td><td align='left'>[[+(dates)]]</td><td align='left'>[[SUBSTR]]</td><td></td></tr>
 +
 +
{{Languages}}

Latest revision as of 17:30, 28 February 2015

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