ID | fullname | pay |
---|---|---|
2 | a | ¥500.00 |
4 | a | ¥600.00 |
5 | a | ¥700.00 |
6 | b | ¥800.00 |
7 | b | ¥55.00 |
查询结果:
查询1
fullname
a
¥700.00
a
¥600.00
a
¥500.00
a 小计
¥1,800.00
b
¥55.00
b
¥800.00
b 小计
¥855.00
总计
¥2,655.00
联合查询代码:
select fullname,pay from pay
union all
SELECT pay.fullname & " 小计" AS 表达式1, Sum(pay.pay) AS payAll
FROM pay
GROUP BY pay.fullname & " 小计"
UNION ALL select "总计", sum(pay) from pay
ORDER BY fullname;