为此,可以将聚合函数SUM()与GROUP BY子句一起使用。让我们首先创建一个表-mysql> create table DemoTable
-> (
-> EmployeeName varchar(20),
-> JoiningDate date,
-> Salary int
-> );
使用插入命令在表中插入一些记录-mysql> insert into DemoTable values('David','2019-11-02',400);
mysql> insert into DemoTable values('Robert','2018-11-25',100);
mysql> insert into DemoTable values('Bob','2019-12-14',600);
mysql> insert into DemoTable values('Carol','2019-11-03',300);
使用select语句显示表中的所有记录-mysql> select * from DemoTable;
这将产生以下输出-+--------------+-------------+--------+
| EmployeeName | JoiningDate | Salary |
+--------------+-------------+--------+
| David | 2019-11-02 | 400 |
| Robert | 2018-11-25 | 100 |
| Bob