目前，我有三列批次資料。每批都有不同的日期戳設定的共同價值。我正在嘗試計算每個公共值集的分組數。下面的示例：表名 = Data1
Position Lot Date
1 ABCD 2021-10-01 15:00.000
1 ABCD 2021-10-01 15:30.000
1 ABCD 2021-10-01 15:45.000
2 ABCDE 2021-10-01 19:00.000
2 ABCDE 2021-10-01 19:56.000
2 ABCDE 2021-10-01 20:00.000
Output expected would be:
Position Count Lot
1 3 ABCD
2 3 ABCDE
Select DISTINCT COUNT(POSITION) AS COUNT, LOT
FROM DATA1
GROUP BY POSITION;
我得到 2 計數而不是 3。
uj5u.com熱心網友回復：
DISTINCT適用于整個結果集，通常應用不正確。根據 6 行樣本資料，我的第一個猜測是：
SELECT Position, Lot, [Count] = COUNT(*)
FROM dbo.Data1
GROUP BY Position, Lot;
uj5u.com熱心網友回復：
檢查這個。
SELECT Position, COUNT(Position) AS Count, Lot
FROM DATA1
GROUP BY Position, Lot
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/412678.html
標籤：