22,209
社区成员
发帖
与我相关
我的任务
分享
mysql> SELECT * FROM TABLEWORK;
+------+------+--------+
| eid | cid | salary |
+------+------+--------+
| E01 | C01 | 2000 |
| E02 | C01 | 3000 |
| E02 | C02 | 1000 |
| E03 | C03 | 6000 |
| E04 | C01 | 4000 |
| E04 | C02 | 7000 |
| E05 | C03 | 600 |
+------+------+--------+
7 rows in set (0.00 sec)
mysql> SELECT SUM(SALARY) FROM TABLEWORK WHERE CID = 'C01'; --公司号
+-------------+
| SUM(SALARY) |
+-------------+
| 9000 |
+-------------+
1 row in set (0.06 sec)