Claudine, OK, the squirrels are turning the wheel, and the synapses are beginning to spark.
Was this a way to "rank" rows based on the order by clause? The solution we used, I think, had to do with counting all rows that were greater than the ranking value in a "group by", and it was extremely impractical for large data sets. Bill On Tue, Apr 21, 2009 at 10:12 AM, Bill Downall < [email protected]> wrote: > Claudine, > I'm listening, but not remembering completely. And my ancient copy of that > book is 1500 miles away from me. What exactly do you want to do? See > sequence numbers on a SELECT from a table that doesn't have sequence > numbers? > > Bill > > On Tue, Apr 21, 2009 at 9:45 AM, Claudine Robbins < > [email protected]> wrote: > >> With a plug for Bill Downall and David Blocker’s excellent “Advanced >> SQL” book which, to this day, remains a very valuable resource and is not >> routinely included in the resources for R:BASE… I’ve searched for an hour, >> both in the book and in my email Rbase-l archives… >> >> >> >> I’m looking for that special UNION statement (Bill, are you there?) to >> create a sequence numbering on the fly. >> >> >> >> TIA, >> >> >> >> Claudine** >> >> >> > >
