数据库内有 LO 113.001 -113.999 and LA 22.001- 22.999
比如 113.001-113.002 and 22.001-22.004 方块内 有数据 而有 n多这种方块 查询 这些方块内有多少数据 并排序
select * from test where LO between 113.001 and 113.002 and LA between 22.001 and 22.004 order by LO,LA desc
select *,count(LO) as LO,count(LA) as LA from test where LO between 113.001 and 113.002 and LA between 22.001 and 22.004 order by LO,LA desc