create table `test`(`id` int(11) not null auto_increment,`province` char(50) not null comment '省份名称',`city` char(50) not null comment '城市名称',primary key(`id`),unique key `idx`(`province`, `city`))engine = innodb;
select province, count(*) c from test where city like '%州' group by province order by c desc, province desc limit 2,1
select province, count(*) c from test where city like '%州' group by province order by c desc, province desc limit 1,2
select province, count(*) c from test where city like '州%' group by province order by c desc, province desc limit 2,1
select province, count(*) c from test where city like '州%' group by province order by c desc, province desc limit 1,2
