select count(1) from rm_shxmxxb select count(1) from rm_shxmxxb where jszt='yj' select count(1) from rm_shxmxxb where jszt='zj' select count(1) from rm_shxmxxb where jszt='nj' select hlmc, hlcd from rm_river where length(hlmc) >= 3 and hlmc like '%河' order by hlcd DESC limit 10 select count(1) from rm_shxmxxb where xmlx='bzgc' select count(1) from rm_shxmxxb where xmlx='zbgc' select count(1) from rm_shxmxxb where xmlx='dfgc' select count(1) from rm_shxmxxb where xmlx='xjbgc' select count(1) from rm_shxmxxb where xmlx='skgc' select count(1) from rm_shxmxxb where xmlx='lhbgc' select count(1) from rm_shxmxxb where xmlx='gxgc' select count(1) from rm_shxmxxb where xmlx='qlgc' select count(1) from rm_shxmxxb where xmlx='szgc' insert into rm_xcjgjl(id,jsxmmc) values(#{id},#{jsxmmc}) delete from rm_xcjgjl where id=#{id} update rm_xcjgjl set jsxmmc=#{jsxmmc} where id=#{id} SELECT substr(xzqh,4,6)AS xzqh,count(1) AS zj from rm_shxmxxb where jszt='zj'and xzqh!='' GROUP BY substr(xzqh,4,6)ORDER BY zj asc -- select replace(xzqh,'德州市','') AS xzqh,count(1) from rm_shxmxxb where xzqh like '%德州市%' and jszt='zj' GROUP BY xzqh SELECT substr(xzqh,4,3)AS xzqh,count(1) AS nj from rm_shxmxxb where jszt='nj'and xzqh!='' GROUP BY substr(xzqh,4,3) ORDER BY nj asc SELECT xmlx,count(1) from rm_shxmxxb GROUP BY xmlx select jsxmmc, count(1) as num from rm_xcjgjl GROUP BY jsxmmc ORDER BY num ASC