如何用达梦语句实现MySQL数据库中的group by效果

Question

select
y.stdname as zzjg,
n.stdname as km,
sum(t.DZXWXYS) as dzxys,
sum(t.RCWXYS) as rccbys
from WXYSMXN_FD as t
left join MD_ORG as y on t.unitid=y.recid
left join WXYSKM as n on t.wxyskm=n.recid
where y.recid = @unitid
and m.recid = @department
group by t.WXYSKM

Answer 1

可以参考官方文档的教程：
https://eco.dameng.com/docs/zh-cn/sql-dev/practice-single-table.html