SQL Basic Function

Definition:

To help doing difficult duties.

---

Command Example:

• Aggregation Function:
  AVG()
  COUNT()
  MAX()
  MIN()
  SUM()

• Date Function:
  DATE()
  DAY()
  MONTH()
  YEAR()

• String Function:
  LEN/LENGTH()
  MID()
  SPACE()
  TRIM()
  LOWER()
  UPPER()

• Other Function:
  ABS()
  CHAR/CHR()
  INT()

---

‘Eazy and basic.’By secondary 6 student