mysql 排名

最新推荐文章于 2023-03-29 11:55:19 发布

mutian.wang

最新推荐文章于 2023-03-29 11:55:19 发布

阅读量145

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/u013027894/article/details/106790437

版权

mysql 专栏收录该内容

12 篇文章 1 订阅

订阅专栏

在这里插入图片描述

SELECT b.company_hired_id  companyHiredId,b.geshu voteRecodeCount,rownum topNum FROM
    (
        SELECT t.*, @rownum := @rownum + 1 AS rownum
        FROM (SELECT @rownum := 0) r,
        (
         select company_hired_id,count(company_hired_id) geshu
         from botp_ceo_vote_recode
         group by company_hired_id
         order by geshu desc
        ) AS t
    ) AS b WHERE b.company_hired_id = 21