Difference between revisions of "FUNCTIONS"

From SQLZOO
Jump to: navigation, search
Line 3: Line 3:
 
<table>
 
<table>
 
<tr><th></th><th></th><th></th><th></th></tr>
 
<tr><th></th><th></th><th></th><th></th></tr>
<tr><td align='left'>[[ABS]]</td><td align='left'>[[CURRENT_TIMESTAMP]]</td><td align='left'>[[LENGTH]]</td><td align='left'>[[+ INTERVAL]]</td><td align='left'>[[SUBSTRING(ansi)]]</td></tr>
+
<tr><td align='left'>[[ABS]]</td><td align='left'>[[CURRENT_TIMESTAMP]]</td><td align='left'>[[LENGTH]]</td><td align='left'>[[+ INTERVAL]]</td><td align='left'>
<tr><td align='left'>[[AVG]]</td><td align='left'>[[DATEPART]]</td><td align='left'>[[MAX]]</td><td align='left'>[[+ (string)]]</td><td align='left'>[[SUBSTRING]]</td></tr>
+
<tr><td align='left'>[[Strings]]</td><td align='left'>[[DAY]]</td><td align='left'>[[MIN]]</td><td align='left'>[[POSITION]]</td><td align='left'>[[SUM]]</td></tr>
+
<tr><td align='left'>[[CASE]]</td><td align='left'>[[DIV]]</td><td align='left'>[[MINUTE]]</td><td align='left'>[[QUARTER]]</td><td align='left'>[[TAN]]</td></tr>
+
<tr><td align='left'>[[CAST]]</td><td align='left'>[[EXTRACT]]</td><td align='left'>[[MOD]]</td><td align='left'>[[RANK]]</td><td align='left'>[[TO_CHAR(dates)]]</td></tr>
+
<tr><td align='left'>[[CEIL]]</td><td align='left'>[[FLOOR]]</td><td align='left'>[[MONTH]]</td><td align='left'>[[REPLACE]]</td><td align='left'>[[TRIM]]</td></tr>
+
<tr><td align='left'>[[COALESCE]]</td><td align='left'>[[HOUR]]</td><td align='left'>[[NULLIF]]</td><td align='left'>[[RIGHT]]</td><td align='left'>[[YEAR]]</td></tr>
+
<tr><td align='left'>[[CONCAT]]</td><td align='left'>[[IFNULL]]</td><td align='left'>[[NVL]]</td><td align='left'>[[ROUND]]</td><td></td></tr>
+
<tr><td align='left'>[[COS]]</td><td align='left'>[[INSTR]]</td><td align='left'>[[PATINDEX]]</td><td align='left'>[[SECOND]]</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>
+
 
+
{{Languages}}
+

Revision as of 12:06, 23 April 2014

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+ INTERVAL
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense