| Subject | Re: [ib-support] SUM + row_count |
|---|---|
| Author | Nick Upson |
| Post date | 2002-11-22T17:03:49Z |
SELECT SUM("col_1"), count(*) FROM table where "col_2"="2" INTO :answer1,
:answer2;
In article <002801c29219$cb1fc5d0$cb01a8c0@vilkasa>, wrote:
:answer2;
In article <002801c29219$cb1fc5d0$cb01a8c0@vilkasa>, wrote:
> What is SQL way to know how many rows was selected to make SUM in following
> situation:
>
> SELECT SUM("col_1") FROM "table" where "col_2"="2" INTO :"answer";
>