小吳 VBQA 程式設計討論

Select StationID As [站別],Sum(Amount) As [檢驗總數],Sum(NG) As [不合格數], (Sum(NG)/Sum(Amount) *100) As [不合格率] From STATIS Where (rDate Between '2003/1/10' And '2003/5/10')　Group By StationID
在MS SQL Server 2000
在上面語法中執行沒有錯誤,但是[不合格率]數據都是0,不知道要如何運算才對