表一主表:表二:关联表统计表一的用户对应设备的数量排名,聚合后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.
表一主表:表二:关联表统计表一的用户对应设备的数量排名,聚合后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.