%rowcount on select into statements

From: buu <aha_at_a.com>
Date: Thu, 26 Jun 2008 20:46:13 +0200
Message-ID: <1214505274.375282@news.vmware.amis.hr>


How could I find how many records has been passed by some select statement?

for example, I have an select like:
select sum(count(*) )

    into retval
     from table1
    where field1='1'
    group by field2, field3
    having count(*)>1;

so, I would like to have some like %RowCount attribute to find how many records this query have passed. (notice that there are aggregate functions and grouping).

tnx... Received on Thu Jun 26 2008 - 13:46:13 CDT

Original text of this message