%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>
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