select distinct a.cname,a.id,b.pmoney-b.fmoney as c from C_Customer a,S_StorageForm b where a.id=b.customerid group by a.cname,a.id,c
group by 别名 报错,有无替代方案,求指点。
...全文
208511打赏收藏
为什么在SQL语句的GROUP BY里面不可以使用别名
select distinct a.cname,a.id,b.pmoney-b.fmoney as c from C_Customer a,S_StorageForm b where a.id=b.customerid group by a.cname,a.id,c group by 别名 报错,有无替代方案,求指点。
你可以用个偷懒的方法
select * from
(select distinct a.cname,a.id,b.pmoney-b.fmoney as c from C_Customer a,S_StorageForm b where a.id=b.customerid group by a.cname,a.id,c) as abc group by abc.id................