Re: same reseult set with less column
Date: Fri, 26 Sep 2008 11:40:46 -0700 (PDT)
Message-ID: <96e9b099-37c8-4622-b121-9927955ae5d0@s50g2000hsb.googlegroups.com>
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 Received on Fri Sep 26 2008 - 13:40:46 CDT