Jazz00
Jazz00

Reputation: 3

Generate an auto increment number in select query increase by 2

I need to generate auto increment number in a select query but increase by 2. so it should look like following

Column1       Column2         Sequence
some Value    some Value      2
some Value    some Value      4
some Value    some Value      6

I tried ROW_NUMBER but didn't find any option to increase the number by 2. I'm using PostgreSQL.

Upvotes: 0

Views: 350

Answers (1)

eshirvana
eshirvana

Reputation: 24568

select * , row_number() over () * 2
from table;

Upvotes: 1

Related Questions