How do i create index column in sql?

Question

I'm using SQL-Server 2005.

I have table with many columns, rows i select have where clause which makes impossible to use identity as indexer. I want select all these row + indexer row (acting like identity).

example

2 jack

4 thomas

8 james

to

1 2 jack

2 4 thomas

3 8 james

thanks

Michael Pakhantsov · Accepted Answer · 2010-07-27 09:05:07Z

2

Use rank function or row_number (http://www.databasejournal.com/features/mssql/article.php/3661461/New-Ranking-Functions-within-SQL-Server-2005.htm)

select rank() OVER (ORDER BY list of your columns) as Id, 
your_column_1, your_column_2 ...
from your table

answered Jul 27, 2010 at 9:05

Michael Pakhantsov

25.5k7 gold badges63 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

How do i create index column in sql?

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