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

• Return average number. – AVG
• Count the number of records. – COUNT
• Return largest value of selected column. – MAX
• Return minimum value of selected column. – MIN
• Return standard deviation of selected column. – STDDEV, STDEV
• Return summation of selected column. – SUM

Character Functions

• Convert character to ASCII code – ASCII
• Conver ASCII code to character – CHAR, CHR
• Return a starting position in a specific character – CHARINDEX
• Concatenate strings – CONCAT
• Convert the first character to uppercase and rest of characters remain lowercase – INITCAP
• Return a location of specific substring – INSTR
• Retrun a left part of character string with specific number of characters – LEFT
• Return a length of characters or text – LEN, LENGTH
• Convert character to lowercase – LOWER
• Pad the left side of a string with a specifice character – LPAD
• Remove all specific character from a left side of string – LTRIM
• Convert Unicode to character – NCHAR, NCHR
• Replicate a specific value for specific number of times. – REPLICATE
• Replace characters with specific characters – REPLACE
• Reverse an order of charcters in a string – REVERSE
• Return a right part of character string with specifice number of characters – RIGHT
• Pad the right side of a string with a specific character – RPAD
• Remove all specific character from a right side of string – RTRIM
• Return strings of space – SPACE
• Convert numeric value to character – STR
• Replace selected characters to another specific characters – STUFF
• Return a portion of strings from specific start position – UBSTR, SUBSTRING
• Search characters and replace them to another characters – TRANSLATE
• Delete specific characters from strings – TRIM
• Convert characters to unicode – UNICODE
• Convert characters to uppercase – UPPER

Conversion Functions

• Convert data type to another. – CAST
• Return the first parameter which is not null. – COALESCE
• Convert data type to another. – CONVERT
• decode a specific strings – DECODE
• Replace NULL value to specific characters – ISNULL
• Return NULL value if compared expressions are equal – NULLIF
• Replace NULL value to specific characters – NVL
• Replace NULL value to specific characters – NVL2
• Convert date or number data type to character data type – TO_CHAR
• Convert string to datetime data type – TO_DATE
• Convert string to number data type – TO_NUMBER

Datetime Functions

• Return current date and time – CURRENT_TIMESTAMP
• Add date value to date – DATEADD
• Return difference value between date and date – DATEDIFF
• Return character value from date elements – DATENAME
• Return numeric value from date elements – DATEPART
• Return only day element from date – DAY
• Return current date and time(SQL Server) – GETDATE
• Return current system date and time (Oracle) – SYSDATE
• Return current date(Oracle) – CURRENT_DATE
• Return only month element from date value – MONTH
• Return only year element from date value – YEAR
• Return only month element from the difference of 2 date value – MONTHS_BETWEEN
• Return specific element from date value – EXTRACT
• Return last day from specific month – LAST_DAY
• Add month value to date value – ADD_MONTHS
• Return date of next specified date following a given date – NEXT_DAY

Numeric Functions

• Return absolute value – ABS
• Return the minimum integervalue which is equal or grater than specific value – CEIL / CEILING
• Return the largest integer value which is equal or less than specific value – FLOOR
• Return random number – RAND
• Round the number – ROUND
• Return whether value is positive(+), negative(-) or 0(NULL) – SIGN
• Truncate numeric value with specific position – TRUNC
• Return the square of a specific value – SQUARE
• Return the square root of specific value – SQRT
• Return the max value from parameters – GREATEST
• Return the min value from parameters – LEAST
• Return the reminder value of division – MOD
• Return the specific value raised to the power of specific number – POWER
• Return e raised to the power of specific number – EXP