select COUNT(1) as num,c.provinceId,p.name from lv_line l,Lv_City c,Lv_Province p where l.LeaveCtiy = c.code and c.provinceId = p.code and p.kindId =1 and l.IsInland in(1,3) group by c.provinceId,p.name
sql获得各个省份信息条数
最新推荐文章于 2024-05-19 13:01:37 发布