autoincrement number function-postgres

Question

i have a table like this:

id	person
20	adams
20	george
40	jina
46	rico
80	naya
90	john
90	peter
90	richard

i want to find a way to select a new_id starting from 1 and increazing +1 every time id is different. for example i want a select with a result like this:

new_id	id	person
1	20	adams
1	20	george
2	40	jina
3	46	rico
4	80	naya
5	90	john
5	90	peter
5	90	richard

is there any function in postgres doing something like that?

Zaynul Abadin Tuhin · Accepted Answer · 2022-02-16 11:13:25Z

2

use dense_rank()

select dense_rank()over(order by id) as newid,id,persion
from table_name

demo link

answered Feb 16, 2022 at 11:13

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

autoincrement number function-postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related