1、查询小于20岁的人信息
String hql20="SELECT id, birthday,DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d')) AS age from hrd_staff where status=? and company=? group by id having age< ?";
2、查询小于20岁的总人数
SELECT count(*),id, birthday,DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(birthday, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(birthday, '00-%m-%d')) AS age from hrd_staff where status=0 and company='8a2c1b1a540dcdb701540f0ea3200006' group by age having age<20
不详细看sql 可能看不到区别,但是我们你详细看能发现 group by 一个是id 一个是age 因为id 不可能重复所以是所有人,而group by age 就是按照age 分组 在获取count(*)的值相加就是小于20岁的人的的总数