当前位置：网站首页>MySQL circularly adds sequence numbers according to the values of a column

MySQL circularly adds sequence numbers according to the values of a column

2022-04-23 05:03:00 【Great Wall ol】

A table has a primary key id, One job number . Now the job number repeats , Find out all the duplicate data of the job number , And add... After the job number of these data 01,02,03

SELECT
	rownu,
	tb.jobid,
	(rownum1 - d.minvalue)
FROM
	(
		SELECT
			@rownum1 :=@rownum1 + 1 AS rownum1,
			jobid
		FROM
			tablea,
			(SELECT @rownum1 := 0) t
	) tb
LEFT JOIN (
	SELECT
		min(rownum) minvalue,
		jobid
	FROM
		(
			SELECT
				@rownum :=@rownum + 1 AS rownum,
				jobid
			FROM
				tablea,
				(SELECT @rownum := 0) t
		) tc
	GROUP BY
		jobid
) d ON (tb.jobid = d.jobid);

The effect is as follows
Insert picture description here

版权声明
本文为[Great Wall ol]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220552270339.html

边栏推荐

猜你喜欢

随机推荐