SELECT
(@i:=@i + 1) AS id, m.*
FROM
(SELECT
DATE_FORMAT(c.report_time, '%Y') AS report_year,
c.unit_id,
COUNT(1) fix_num
FROM
subway.t_work_order_report_cart c
WHERE
c.node_state = '已完工'
GROUP BY c.unit_id , DATE_FORMAT(c.report_time, '%y')
ORDER BY fix_num DESC) m,
(SELECT @i:=0) AS it
mysql 虚拟自增ID
最新推荐文章于 2024-04-17 15:29:19 发布