select name,age,gender from person_inf where amout < 10000 group by 1,2
等于:
select name,age,gender from person_inf where amout < 10000 group by name,age
group by 1,2的意思是根据select参数的第1、第2列进行分组
select name,age,gender from person_inf where amout < 10000 group by 1,2
等于:
select name,age,gender from person_inf where amout < 10000 group by name,age
group by 1,2的意思是根据select参数的第1、第2列进行分组