Re: same reseult set with less column

From: <dt1649651_at_yahoo.com>
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

Original text of this message