select sum(K.xfje) as mzj, V.imonth from txf K
inner join
(SELECT C.imonth FROM (SELECT * FROM (SELECT year(A.idate) & '-' & month(A.idate) AS imonth FROM txf AS A) AS B) AS C GROUP BY C.imonth) as V
on V.imonth = year(k.idate) & '-' & month(k.idate)
group by V.imonth;
SQL-LINE
最新推荐文章于 2025-06-09 09:07:01 发布