1.Mysql数据库中
不仅仅只能按照表中存在的字段分组,也可以按照自己取的别名来分组,切记思维定式
SELECT
round( TIMESTAMPDIFF( MONTH, date( gmt_create ), date( NOW( ) ) ) / 12 ) AS age,
count( * )
FROM
edu_teacher
GROUP BY
age
desc edu_teacher
select now()
2.orcle数据库中
orcle中并不支持别名分组的写法,必须取别名字段之前的表达式来进行分组
正确的写法:
select substr(a0101,1,2) as age,count(*) from a01 group by substr(a0101,1,2)