SQL

SQL

SQL Aggregate

SQL Aggregate

Aggregate

  • AVG() -
  • COUNT() -
  • FIRST() -
  • LAST() -
  • MAX() -
  • MIN() -
  • SUM() -

SQL Scalar

SQL Scalar

Scalar

  • UCASE() -
  • LCASE() -
  • MID() - MySql
  • SubString(1end) -
  • LEN() -
  • ROUND() -
  • NOW() -
  • FORMAT() -

Aggregate Scalar