Re: same reseult set with less column

On Sep 29, 9:13 am, "dt1649..._at_yahoo.com" <dt1649..._at_yahoo.com> wrote:
> On Sep 26, 3:18 pm, ddf <orat..._at_msn.com> wrote:
>
> > I have an example in this blog post using ROWNUM to process data and
> > massaging the original query to eliminate the rownum value:
>
> >http://oratips-ddf.blogspot.com/2008/07/preserving-union.html
>
> > It's toward the bottom of the post.
>
> Thanks, David. I looked at it but could not find where you mention the
> rownum. I may missed it. Will check your other blog articles, though.
>
> DT

I stand corrected, it's not using ROWNUM but an artificially generated sort column. However, the process to eliminate that value is the same as what you'd use to eliminate ROWNUM values.

David Fitzjarrell Received on Mon Sep 29 2008 - 12:12:59 CDT