我有兩張桌子
表格1：
'table1Id' int,
'date' date
表 2：
'table2Id' int,
'table1Id' int,
'switchVal' int DEFAULT NULL,
FOREIGN KEY 'table1Id' REFERENCES table1('table1Id')
我如何去顯示按日期分組的計數 table1Id 假設switchVal是not null？
uj5u.com熱心網友回復：
像這樣的東西：
SELECT SUM(dbo.Table_1.table1Id) AS Expr1, dbo.Table_2.switch1val, dbo.Table_1.date
FROM dbo.Table_1 INNER JOIN
dbo.Table_2 ON dbo.Table_1.table1Id = dbo.Table_2.table1id
GROUP BY dbo.Table_2.switch1val, dbo.Table_1.date
HAVING (dbo.Table_2.switch1val IS NOT NULL)
uj5u.com熱心網友回復：
您需要根據列 table1Id 加入表和分組依據。
Select t1.date, count(t1.table1Id) as 'Count' from Table1 t1 inner join Table2 t2 on t1.table1Id = t2.table1Id
where t2.[switchVal] is not null
group by t1.date
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/353907.html
標籤：sql