Re: Creating sequence for group by in a query?

> Well, in actuality, yes, this is what I want, but the problem is that
> the "GROUP" column needs to be unique (it's a key)

Yea BTW in your example it definitely wasn't unique. If you need unique then use row_number instead (of course it starts from 1 every time) or read about other analytic functions in data warehousing guide.

Gints Plivna
http://www.gplivna.eu/ Received on Thu Jun 29 2006 - 17:06:07 CDT