MySQL 查询做排名
只要数据有相同的排名就一样,排名依次排序 SELECT obj.Dept_Name, obj.CountNo, CASE WHEN @rowtotal = obj.CountNo THEN @rownum WHEN @rowtotal := obj.CountNo THEN @rownum :=@rownum + 1 WHEN @rowtotal = 0 THEN @rownum :=@rownum + 1 END AS rownum FROM (select * from (select Dept_Name,count(1) CountNo from view_my_pic_sign where 1=1 group by Dept_Name) x order by x.CountNo desc) AS obj, (SELECT @rownum := 0 ,@rowtotal := NULL) r
执行结果