庫存表統計問題asp

sql = "SELECT sname AS [設備名稱]"

sql = sql & ",SUM(IIF(zt='新品',1,0)) AS [新品]"

sql = sql & ",SUM(IIF(zt='運行',1,0)) AS [運行]"

sql = sql & ",SUM(IIF(zt='待修',1,0)) AS [待修]"

sql = sql & ",SUM(IIF(zt='報廢',1,0)) AS [報廢]"

sql = sql & ",SUM(IIF(zt='D',1,0)) AS [未知]"

sql = sql & " FROM [aa] GROUP BY [sname]"

修改了下...

上一篇:汽車啟動不加油啟動就熄火怎麽回事

下一篇:IPIP隧道能不能通過端口映射