如果 B 列的總和等于 A 列的 0，則需要幫助計算 A 列中的值。
SELECT
A, SUM(B) --???
FROM table
WHERE DATE = 'yyyy-mm-dd'
AND B = 0
GROUP BY A
uj5u.com熱心網友回復：
若干個 A，其中 sum(B)=0。
select count(*)A
from (
SELECT A
FROM table
WHERE DATE = ... -- your date here
GROUP BY A
HAVING SUM(B)=0
) t
uj5u.com熱心網友回復：
select count(Distinct A)
from (
SELECT sum(B) as B, A
FROM table
GROUP BY A
) a
Where B = 0 and DATE = 'yyyy-mm-dd'
uj5u.com熱心網友回復：
它現在正在作業。謝謝大家分享解決方案。
select count(*) MACHINE_CODE
from (
SELECT MACHINE_CODE
FROM CNC_hourly_logging chl
WHERE C_DATE ='2022-01-28'
AND cast(convert(char(8), [C_TIME], 108) as time) BETWEEN cast('08:00' as time) AND cast('18:30' as time)
GROUP BY MACHINE_CODE
HAVING SUM(TOTAL_PRODUCTION)=0
) t
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/428468.html