溫馨提示×

mysql中分組函數(shù)怎么用

養(yǎng)魚的貓咪
126
2021-03-18 13:01:07
欄目: 云計算

mysql中分組函數(shù)怎么用

mysql中常見的分組函數(shù)有sum()求和函數(shù)、avg()求平均值函數(shù)、max()求最大值函數(shù)、min()求最小值函數(shù)、和count()計算個數(shù)函數(shù)幾種,使用方法如下:

1.sum() 求和

select sum(salary) from employees;

2.avg() 求平均值

select avg(salary) from employees;

3.max() 求最大值

select max(salary) from employees;

4.min() 求最小值

select min(salary) from employees;

5.count() 計算個數(shù)

select count(commission_pct) from employees;

0