SQL Command Dictionary
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
