Need to add a number column

[sachin05]

I want to add a column to my select statement that would generate
consecutive numbers:

for example:

Col1 Col2
user1 1
user2 2
user3 3
user4 4

(need to generate col2)

any ideas?
sachin

 

[RickCole]

From the snippet of your table definition and records shown this should work but might need some slight modification if they are more involved. I’m assuming User1 to 4 is a unique id.

select a.Col1,
(select count(distinct b.Col1) from Tablename b
where (a.Col1 >= b.Col1)) as Col2
from Tablename a
order by a.Col1

Rick.