Re: giving tuples a number to make them unique..

>> i need to number rows in a _select_-statement to get unique tuples
>> with ascending instanceids:
>>
>> name, instanceid
>> a, 1
>> a, 2
>> b, 1
>> c, 1
>> c, 2
>> c, 3
>> d, 1

>Select rownum,name,instanceid from mytab order by name,instanceid;

perhaps the description of my problem was too brief. the unique values i need to create are in the column instanceid. the relation above describes the result when i start with 2*'a', 1*'b', 3*'c' and one 'd'.

ciao, jan Received on Fri Jan 15 1999 - 04:01:48 CST