Re: Difficult Query Question!!!

On 2005-11-03, tal fts <tal.fts_at_gmail.com> wrote:
> Hi
>
> i have a query which returns me an xml of the rows using xmlagg
> i want to limit the rows it return , which is not the problem (using
> rownum < num)
>
> the problem is that i want to combine in the same sql , the real rows
> count using count(*)
> like if i didnt added the rownum < num)
>
> the result should be a count field with the real rowscount of the query
> and an xml of the first [num] rows
>
> is it possible?, right no i am doing 2 sepearte quries, which is a
> waste of time

Already answered in comp.databases.oracle.misc.

Please don't post the same question into different groups. I even consider cross posting into comp.database.orace.{misc,server} bad; most people will read both groups anyway.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/