全部產品
Search
文件中心

PolarDB:彙總函式

更新時間:Jul 06, 2024

本文介紹了PolarDB-X 1.0支援及不支援的彙總函式。

支援函數

PolarDB-X 1.0支援如下彙總函式:

函數名描述
AVG()Return the average value of the argument
COUNT()Return a count of the number of rows returned
COUNT(DISTINCT)Return the count of a number of different values
MAX()Return the maximum value
MIN()Return the minimum value
SUM()Return the sum

不支援函數

與MySQL5.7相比,PolarDB-X 1.0暫不支援如下彙總函式:

函數名描述
BIT_AND()Return bitwise AND
BIT_OR()Return bitwise OR
BIT_XOR()Return bitwise XOR
GROUP_CONCAT()Return a concatenated string
STD()Return the population standard deviation
STDDEV()Return the population standard deviation
STDDEV_POP()Return the population standard deviation
STDDEV_SAMP()Return the sample standard deviation
VAR_POP()Return the population standard variance
VAR_SAMP()Return the sample variance
VARIANCE()Return the population standard variance