我正在嘗試解決此 SQL 練習。但我不知道該怎么做。有人有好主意嗎?
試試看:

uj5u.com熱心網友回復:
就像是:
SELECT workflow
, case when min(status) = max(status) THEN min(status) -- if all status is same, set to status
when min(case when status = 'Error' then 0 end) = 0 then 'Intederminate' -- if any status is error then intedermined
else 'Running' end
FROM #ProcessLog
group by workflow
也許?
轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/533826.html
