MySql的聚合后排序

表一主表：表二：关联表统计表一的用户对应设备的数量排名，聚合后SELECT @i:=@i+1 AS number,`name`,numFROM(SELECT sur.`name`,count(*) AS numFROM business_device_info bdiINNER JOIN security_user sur ON bdi.user_id=sur.idINNER JOIN security_role sr ON sur.role_id = sr.idW.