Anilrgowda

Question: How do I assign a distinct unique number to each field returned. I prefer to do it in sql and not create an index as the table as I do not have sole control of the table. In the below desired output description this would be RowIndex.

SQL 2000
Statement to add rowindex to:
select distinct(Description) as LawSpecialty from lawspecialty

desired output
LawSpecialty RowIndex
Bankrupcy 1
Divorce 2

------------------

Anilrgowda

select * from (

SELECT a.Description,
Id = ( SELECT COUNT(1) FROM (SELECT DISTINCT(Description) FROM LawSpecialty ) b WHERE a.Description > b.Description ) +1
FROM (SELECT DISTINCT(Description) FROM LawSpecialty ) A
) C
where id in (1,2,3)

------------------