group by 语句里面不可以使用别名,例如
SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer
但是不可以:
SELECT Customer AS cus , SUM(OrderPrice) FROM Orders GROUP BY cus
group by 语句里面不可以使用别名,例如
SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer
但是不可以:
SELECT Customer AS cus , SUM(OrderPrice) FROM Orders GROUP BY cus
转载于:https://www.cnblogs.com/dimsumboy/p/7263571.html