Re: same reseult set with less column

<dt1649651_at_yahoo.com> schreef in bericht news:96e9b099-37c8-4622-b121-9927955ae5d0_at_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

Sorry, you lost me.....

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