改成这样
Select numbers,jodate,eveidname,submiteridname,sum(amount) As [totalamount],sum(iif(cheks = true , 1, 0)) as [已审核],sum(iif(cheks = false, 1, 0)) as [未审核] ,count(numbers) As [rowcount] From {pm0102} Group By numbers,jodate,eveidname,submiteridname
加好友 
发短信
Post By：2018/12/16 20:04:00 [显示全部帖子]
