1.group 用法
很多时候我们需要分组函数来统计数据,在此过程中因为业务问题可能会用到别名,此时sql可能会写成如下样子:
SELECT a.FEE_RESERVE AS FEE_OTHER, COUNT(1) AS COUNT_NO FROM T_EXPENSES_BILL a GROUP BY a.FEE_RESERVE AS FEE_OTHER;
此时会报错:命令未正确结束,原因在于此处的 “AS” ,数据库将它当作一个函数了,造成sql错误;
解决方式:group by 之后的不要用别名,即:去掉 “AS”及其后面的别名,如下:
SELECT a.FEE_RESERVE AS FEE_OTHER, COUNT(1) AS COUNT_NO FROM T_EXPENSES_BILL a GROUP BY a.FEE_RESERVE;