如果select后有聚合函数,那么group by 后需要把除了聚合函数的给去了,其他都要
例如:select e.XH,i.HTH,i.QYSJ,i.HTLX,i.XMJL,u.ZFDW,i.HTMC,count(i.ID), m.HTZJE ,b.SSJE_bidding,b.ZFSJ_bidding,b.JHHKSJ_bidding,u.SSJE_unit,u.ZFSJ_unit,u.JHHKSJ_unit,f.KPJE,f.DZJE,o.HTZT from information_Dentmon i
left join contract_money_Dentmon m on i.ID=m.PID
left join bidding_Dentmon b on i.ID=b.PID
left join unit_Dentmon u on m.ID=u.PID
left join contract_received_Dentmon r on i.ID=r.PID
left join contract_refund_Dentmon f on i.ID=f.PID
left join bad_dept_Dentmon d on i.ID=d.PID
left join inner_Dentmon n on i.ID=n.PID
left join buff_Dentmon o on i.ID=o.PID
left join enclosure_Dentmon e on i.ID=e.PID
group by e.XH,i.HTH,i.QYSJ,i.HTLX,i.XMJL,u.ZFDW,i.HTMC, m.HTZJE ,b.SSJE_bidding,b.ZFSJ_bidding,b.JHHKSJ_bidding,u.SSJE_unit,u.ZFSJ_unit,u.JHHKSJ_unit,f.KPJE,f.DZJE,o.HTZT
sqlserver中的关联查询与聚合函数
最新推荐文章于 2024-08-21 19:35:09 发布