1、SQL聚合函数:
- MAX(最大值)
- MIN(最小值)
- AVG (平均值)
- SUM (和)
- COUNT(数量)
2、大于25岁的员工的最高工资 :
SELECT MAX(FSalary) FROM T_Employee WHERE FAge>25
3、最低工资和最高工资:
SELECT MIN(FSalary),MAX(FSalary) FROM T_Employee
4、例:
select count(*) from T_Employee;
select max(FSalary) from T_Employee;
select min(FSalary) from T_Employee;
select avg(FSalary) from T_Employee
select sum(FAge) from T_Employee;
select count(*) from T_Employee
where FSalary>=5000;
5、select COUNT(*) from book //查询book表中有多少行数据。汇总,统计行数。
还可以在后面加上where条件。系统函数。