SELECT SUM(num),BIEMING.utype FROM USER,(SELECT ID,CASE type WHEN 1 THEN '类别1' ELSE '类别2' END AS utype FROM USER) BIEMING EHERE BIEMING.ID=USER.ID GROUP BY BIEMING.utype;
如下的SQL语句: SELECT SUM(num),CASE type WHEN 1 THEN '类别1' ELSE '类别2' END AS utype FROM USER GROUP BY utype; 执行时会报invalid identifi的错误,这是因为在SQL执行的时候,WHERE和GROUP语句在字段分类之前就已经执行了,在此期间,别名还没有生效,因此找不到指定