select (@i:=@i+1) as i,a.DISTRICT,a.AREA,a.LOCFISCALSPD_PUBLICSPD_SCALE FROM
(select DISTRICT,area, LOCFISCALSPD_PUBLICSPD_SCALE from tblind where type = 'AREA' group by LOCFISCALSPD_PUBLICSPD_SCALE ) as a,(select @i:=0) as it
order by a.LOCFISCALSPD_PUBLICSPD_SCALE desc
mysql先分组后排序,加排序号
最新推荐文章于 2024-04-24 18:22:58 发布