JZTXT

SQL之聚合函数

发布时间 2023-03-22 21:16:57作者: 默玖

1、count

select count(*) from student;

2、max

select max(age) from student;

3、min

select sname,min(age) from student;

4、sum

select sum(age) from student;

5、avg

select avg(age) from student;