Re: same reseult set with less column

From: ddf <>
Date: Fri, 26 Sep 2008 13:18:50 -0700 (PDT)
Message-ID: <>

On Sep 26, 1:40 pm, "" <> 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:

It's toward the bottom of the post.

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

Original text of this message