select JZRQ AS 日期,SY AS 实_预,Fname_l3 AS 预算单元,Fnumber_L3 AS 科目序号,fname_l4 as 科目名称,sum(JE) as 金额,SFSS ,SFGB ,brNumber as 品牌编码,brName as 品牌,prtNumber as 产品编码,prtName AS 产品,seaNumber as 期数编码,seaName as 期数,FPeriodNumber as 会计期间,FORMAT(CONVERT(date, JZRQ + '-01'), 'yyyy"年"M"月"') + GSBM AS 匹配项主体 from DM.dbo.T_PP_KBwhere SFGB='是' and JZRQ ='2024-02' and Fname_l3 LIKE '%事业部%' and SY ='实'group by JZRQ,SY,Fname_l3,Fnumber_L3,fname_l4,SFSS,SFGB,brNumber ,brName ,prtNumber ,prtName ,seaNumber,seaName,FPeriodNumber,GSBM不知为什么这段SQL一直读不出来,10万行数据内, 有没办法优化一下速度