All Products
Search
Document Center

Analytic functions

Last Updated: Jan 07, 2020

The following analytic functions are supported in the Oracle mode.

  • SUM
  • MIN
  • MAX
  • COUNT
  • AVG
  • LISTAGG
  • ROW_NUMBER
  • RANK
  • DENSE_RANK
  • PERCENT_RANK
  • CUME_DIST
  • FIRST_VALUE
  • LAST_VALUE
  • NTH_VALUE
  • NTILE
  • LEAD
  • LAG

The plan optimization and the operators involved for analytic functions are the same as that in MySQL mode. However, some differences exist in the validation process and specific implementation details.