[給定表]
| 代碼 | 地位 |
|---|---|
| 軸心 | 成功 |
| 軸心 | 成功 |
| 軸心 | 成功 |
| 軸心 | |
| 軸心 | |
| BXYZ | 成功 |
| BXYZ | 成功 |
| BXYZ | 成功 |
| BXYZ | 成功 |
| BXYZ | |
| BXYZ |
訪問 SQL 命令
'''
SELECT [WERKS], count(*) FROM (SELECT DISTINCT Status FROM [Sheet1$]) FROM [Sheet1$] GROUP BY [WERKS]
'''
預期產出
AXYZ-2
BXYZ-2
實際輸出：
FROM 子句中的錯誤
uj5u.com熱心網友回復：
你可以試試：
SELECT COUNT(Code), Code FROM tableName WHERE Status not like 'Success' GROUP BY Code
這適用于所有不等于“成功”的狀態。
uj5u.com熱心網友回復：
如果你把它分成兩組，你可以獲得你想要的輸出
SELECT t1.Code, Count(t1.Code) AS NumStatus
FROM
(SELECT [Sheet1$].Code, [Sheet1$].Status
FROM [Sheet1$]
GROUP BY [Sheet1$].Code, [Sheet1$].Status) AS t1
GROUP BY t1.Code;
![如何計算Access查詢中欄位中的唯一專案并按[feildname]分組？](https://img.uj5u.com/2022/05/30/2e4cc48adb83459cab72c9d458da3bdf.png)
uj5u.com熱心網友回復：
嘗試這個
SELECT code, count(Distinct code , status) FROM [Sheet1$] GROUP BY code
uj5u.com熱心網友回復：
如評論之一所述，您需要考慮 Null 值
SELECT Count(Code) AS CountOfCode, Code
FROM tbl
WHERE [Status] Not Like 'Success' OR [Status] Is Null
GROUP BY Code;
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/482477.html