sql server 某一列求和
SELECT 患者来源,设备类型,检查部位,设备名称,convert(char(10),STUDY_DATE,121) as 日期, count(distinct 就诊人次) as 就诊人次--SUM(就诊人数) AS 就诊人数
FROM dbo.[V_SeePeople]WHERE
STUDY_DATE >= '2019-12-04 00:00:00.000' and STUDY_DATE <= '2019-12-11 23:59:59.000'
and OFDEPARTMENT ='FSK' and ORGNIZATIONCODE ='0101'
GROUP BY 患者来源,设备类型,检查部位,设备名称,convert(char(10),STUDY_DATE,121) --order by convert(char(10),STUDY_DATE,121)
UNION all
select '' ,'' ,'' ,'','合计' ,sum( convert(int,temp.就诊人次))AS 就诊人次 from
(
SELECT top 100 percent 患者来源,设备类型,检查部位,设备名称,convert(char(10),STUDY_DATE,121) as 日期, count(distinct 就诊人次) as 就诊人次--SUM(就诊人数) AS 就诊人数
FROM dbo.[V_SeePeople] WHERE<