SQL Functions

1.Conditional Functions or Control Functions

• CASE
• DECODE

2.Comparison  Functions

• GREATEST
• LEAST

3.General Functions

• NVL
• NVL2
• NULLIF
• COALESCE

4.Aggregate Functions or Group Functions

• AVG
• COUNT
• MAX
• MIN
• SUM

5.Number Functions

• ROUND
• TRUNC
• MOD

6.Date Functions

• MONTHS_BETWEEN
• ADD_MONTHS
• NEXT_DAY
• LAST_DAY

7.Case Manipulation Functions

• UPPER
• LOWER
• INITCAP

8.Character Manipulation Functions

• CONCAT
• LENGTH
• REPLACE
• REVERSE
• TRANSLATE
• LPAD
• RPAD
• LTRIM
• RTRIM
• TRIM
• SUBSTR
• INSTR
• ASCII

9.Analytical Functions

• RANK
• DENSE_RANK
• ROW_NUMBER
• LEAD
• LAG
• FIRST_VALUE
• LAST_VALUE
• CUBE & ROLLUP