Difficult Query Problem

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

10x Received on Thu Nov 03 2005 - 08:42:41 CST