时间戳

首页 > 解决方案 > SELECT 中的 SELECT 语句

sql - SELECT 中的 SELECT 语句

问题描述

我有以下 T-sql 代码

SELECT DISTINCT
    DATEPART(DW, [DATE]) AS datepar,
    DATENAME(dw, [Date]) AS dy,
    EDEN = (SELECT SUM(total) AS UnusedTotal 
            FROM [dbo].[CHEA_CCG_Report] ccg  
            WHERE availability = 'Available' 
             AND [Name of the Location of the Session] in ('Cumberland Infirmary'))
FROM 
    [dbo].[CHEA_CCG_Report] ccg

但是，代码每天都会返回总和。我将如何引用它，以便它带回当天的总和？

谢谢

标签： sqlsql-server

解决方案

也许 a GROUP BYand 在WHERE子句中使用这些条件？

（未经测试）

SELECT
DATEPART(dw, [Date]) AS [datepar],
DATENAME(dw, [Date]) AS [dy],
SUM(total) AS EDEN
FROM [dbo].[CHEA_CCG_Report] AS ccg
WHERE availability = 'Available'
  AND [Name of the Location of the Session] IN ('Cumberland Infirmary')
GROUP BY DATEPART(dw, [Date]), DATENAME(dw, [Date])
ORDER BY [datepar], [dy]

推荐阅读