mysql 查询区间数据 并且排序

数据库内有 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