robrodp
asked on
numbering repetaed records 12 123 1 1234 etc sql ms 2005
I have a table with n records (1 field each) I nee an sqk query that will order them by field and add a consecutive number to each repeted record starting from 1 then 2 then 3 ..until the next different record(field) is reached abd star againnwith 1,2 123,1, etc
Ex
John 1
John 2
Mike 1
Sam 1
Sam 2
Sam 3
Ex
John 1
John 2
Mike 1
Sam 1
Sam 2
Sam 3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you forgot the comma between email and row_number()
and the reason it is giving an error is because it thinks you are trying to alias email as row_number
ASKER
Got it....
Sorry
Sorry
ASKER
I get this error:
Incorrect syntax near ')'.