mysql 我想在使用SELECT语句进行查询时增加一列,列值应如下所示，

2nc8po8w 于 2023-02-28 发布在 Mysql

关注(0)|答案(1)|浏览(125)

name	class	marks	new_column##
jim	1	50	1
jim	2	50	1
jim	3	40	1
tom	4	30	2
tom	3	70	2
tom	2	80	2
tom	1	70	2
tom	5	80	2

The name column changes every time I query but a similar name will come each time(like 5 Herry, 6 Lucy).
So I want a new_column where first similar names are assigned 1 and next similar names will be assigned 2 and so on.

mysql

来源：https://stackoverflow.com/questions/75518411/i-want-a-extra-column-while-querying-using-select-statement-the-column-value-sh

1条答案

按热度按时间

ljsrvy3e1#

您正在查找dense_rank窗口函数：

SELECT   *, DENSE_RANK() OVER (ORDER BY name) AS new_column
FROM     mytable
ORDER BY name

赞(0）回复(0）举报 2023-02-28

我来回答

mysql 我想在使用SELECT语句进行查询时增加一列,列值应如下所示，

1条答案

相关问题

热门标签

最新问答