SELECT
@rownum := @rownum + 1 AS sequence,
e.*
FROM
(SELECT @rownum := 0) r,
(
SELECT
dz.央企名称
FROM
r_db_303127506 dz
GROUP BY
dz.央企名称
) e
Mysql之获取自增序号---sequence(从1开始)
最新推荐文章于 2024-07-03 03:22:23 发布
SELECT
@rownum := @rownum + 1 AS sequence,
e.*
FROM
(SELECT @rownum := 0) r,
(
SELECT
dz.央企名称
FROM
r_db_303127506 dz
GROUP BY
dz.央企名称
) e