SQL Command


Aggregate Functions

AVG | COUNT | MAX | MIN | STDEV or STDDEV | SUM

Character Functions

ASCII | CHAR or CHR | CHARINDEX | CONCAT | INITCAP | INSTR | LEFT | LEN or LENGTH | LOWER | LPAD | LTRIM | NCHAR or NCHR | REPLICATE | REPLACE | REVERSE | RIGHT | RPAD | RTRIM | SPACE | STR | STUFF | SUBSTR or SUBSTRING | TRANSLATE | TRIM | UNICODE | UPPER


Conversion Functions

CAST | COALESCE | CONVERT | DECODE | ISNULL | NULLIF | NVL | NVL2 | TO_CHAR | TO_DATE | TO_NUMBER


Datetime Functions

ADD_MONTHS | CURRENT_DATE | CURRENT_TIMESTAMP | DATEADD | DATEDIFF | DATENAME | DATEPART | DAY | EXTRACT | GETDATE | LAST_DAY | MONTH | MONTHS_BETWEEN | NEXT_DAY | SYSDATE | YEAR


Numeric Functions

ABS | CEIL or CEILING | EXP | FLOOR | GREATEST | LEAST | MOD | POWER | RAND | ROUND | SIGN | SQRT | SQUARE | TRUNC




SQL Command Reverse Dictionary – Introducing SQL Command by purposes


Aggregate Functions



Character Functions



Conversion Functions



Datetime Functions



Numeric Functions




Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>