set row number in select query

[nainakarri]

Hi I have a table with duplicate rows and distinct id. I have written a select query using distinct and selecting only required fields to avoid duplicates. Select dictinct(occassion), startdate from table1 Now what i want is to give unique row number to each distict row For this i tried as below but could not succeed Declare @num int set @num =0 select (set @num = @num+1) as num, dictinct(occassion), startdate from table1 After search in google , i got row_number(). But this i am unable to use as i am using distinct. Can u pls let me know how i can achieve this. Thanks in advance Naina

Naina

[_Damian S_]

What are you going to do with the unique row number? How will it assist you? Where are you using it?

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

[nainakarri]

Hi Thanks for the reply. It is very useful for me. As i will use it in my web page (front end) where other functionality related to this unique number is related to. Please help me to get this. Regards Naina

Naina

[Coding C]

Cant you just use ID in the record from table itself?

Coding C# ExciteTemplate