レンジを区切ってgroup by
select point, floor(point/10000)*10000 hoge, count(*) c from person_point group by hoge order by hoge desc;
truncate関数使った方がいい
select point, truncate(point,-4) hoge, count(*) c from person_point group by hoge order by hoge desc;
select point, floor(point/10000)*10000 hoge, count(*) c from person_point group by hoge order by hoge desc;
truncate関数使った方がいい
select point, truncate(point,-4) hoge, count(*) c from person_point group by hoge order by hoge desc;