初学者心态

摘要： GROUP BY 与count(*) 连用的时候出现问题，读不到数据，后来看网上网友的例子，修改如下：select COUNT(*) from (SELECT MAX(proSaleBillID) as proSaleBillID, proSaleBill.proSaleBillCode, proSaleBill.BusiName,AVG(totalPrice) AS totalPrice ,MAX(receiptBill.realReciAmount) AS realReciAmount ,MAX(proSaleBill.totalPrice-receiptBill.realReciAmou 阅读全文