Re: %rowcount on select into statements
Date: Thu, 26 Jun 2008 14:19:47 -0700 (PDT)
On Jun 26, 1:46 pm, "buu" <a..._at_a.com> wrote:
> 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).
SELECT sum(count(*) ), count(*) rows_passed_into_SUM ...
what you are looking for?
(Sometimes it just takes another pair of eyes.) Received on Thu Jun 26 2008 - 16:19:47 CDT