--insert into huo (openid,shuzi) values ('x','1');
--select count(*) from huo t where t.shuzi='0';
select count(*) count_,t.shuzi from huo t
group by t.shuzi order by count_,shuzi;
--insert into huo (openid,shuzi) values ('x','1');
--select count(*) from huo t where t.shuzi='0';
select count(*) count_,t.shuzi from huo t
group by t.shuzi order by count_,shuzi;
转载于:https://my.oschina.net/u/3206447/blog/906916