Re: same reseult set with less column

From: Shakespeare <>
Date: Fri, 26 Sep 2008 21:36:03 +0200
Message-ID: <48dd3999$0$187$>

<> schreef in bericht
> 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

Sorry, you lost me.....

Shakespeare Received on Fri Sep 26 2008 - 14:36:03 CDT

Original text of this message