Re: same reseult set with less column

On Sep 26, 1:40 pm, "dt1649..._at_yahoo.com" <dt1649..._at_yahoo.com> wrote:
> Thanks everybody. Let me explain what I am really trying to do that
> let me to having the original question.
>
> I use the top-N query using ROWNUM to get data. The returned resultset
> is returned to my web app which uses jdbc to access the the resultset
> and displays data in a table.
> The top-N query returns the extra column of rownum. Some queries in my
> app need the top-N query, some don't. I would like to use only one set
> of code to display the data returned from the resultsets therefore
> some tables will be displayed correctly, some will be displayed with
> an extra column rownum.
>
> That's why I am thinking about having the top-N query resultsets to be
> filtered by some other query to get rid of the column rownum, instead
> of fixing code in the web app for different tables.
>
> Thanks,
>
> DT

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.

David Fitzjarrell Received on Fri Sep 26 2008 - 15:18:50 CDT