Reputation: 3
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