Re: same reseult set with less column

From: William Robertson <>
Date: Mon, 29 Sep 2008 01:27:07 -0700 (PDT)
Message-ID: <>

On Sep 26, 7: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

Can't the Java app decide which columns to display? Or, don't include the row number in the query's SELECT list in the first place, if you don't want to see it. Received on Mon Sep 29 2008 - 03:27:07 CDT

Original text of this message