Re: %rowcount on select into statements
From: Ed Prochak <edprochak_at_gmail.com>
Date: Thu, 26 Jun 2008 14:19:47 -0700 (PDT)
Message-ID: <2754c5aa-3798-4f26-ae28-aa3554c5c8c8@34g2000hsf.googlegroups.com>
Date: Thu, 26 Jun 2008 14:19:47 -0700 (PDT)
Message-ID: <2754c5aa-3798-4f26-ae28-aa3554c5c8c8@34g2000hsf.googlegroups.com>
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).
>
> tnx...
Is
SELECT sum(count(*) ), count(*) rows_passed_into_SUM
...
what you are looking for?
Ed
(Sometimes it just takes another pair of eyes.) Received on Thu Jun 26 2008 - 16:19:47 CDT