1.聚集函数(分组函数)有哪些?
AVG(x)
COUNT(x) //记录行数
MAX(x)
MEDIAN(x) //取中值
MIN(x)
STDDEV(x) //求标准差
SUM(x)
VARIANCE(x) //求方差
聚集函数可以对多行数据进行操作,通常返回一行结果,因此在使用聚集函数时需要注意单行多行的问题
■ The Oracle database has two main groups of functions: single-row functions and
aggregate functions.
■ Single-row functions operate on one row at a time and return one row of output for
each input row. There are five main types of single-row functions: character functions,
numeric functions, conversion functions, date functions, and regular expression
functions.
■ Aggregate functions operate on multiple rows and return one row o