Can my query count sum?

Ivan

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Can my query count sum?

Hi!
I find it interesting is it possible in a query like that

SELECT Sum(Price), Id_field
WHERE My conditions
GROUP BY ...

to count not only the sum of Sum(Price), but SUM(Sum(Price)) I mean the
total Sum for the aggregate field...
And I do think that it might be visual by my DBGrid, so compute by doesn't
seem to be usefull(?).
(D4 and SQL 7)
Thanks, Ivan

Brian Jone

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Can my query count sum?

You need two queries. As you have grouped this one, it will always return a
sum for each of the grouping conditions. To get a sum of all, create another
sql without the group by.

--
Adroit Software Ltd
------------------------------
Remove the nospam. to mail me direct

Quote

Ivan wrote in message <7n6qvl$ls...@forums.borland.com>...
>Hi!
>I find it interesting is it possible in a query like that

>SELECT Sum(Price), Id_field
>WHERE My conditions
>GROUP BY ...

>to count not only the sum of Sum(Price), but SUM(Sum(Price)) I mean the
>total Sum for the aggregate field...
>And I do think that it might be visual by my DBGrid, so compute by doesn't
>seem to be usefull(?).
>(D4 and SQL 7)
>Thanks, Ivan

Ivan

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Can my query count sum?

Thank Brian!
Frankly spaking I already have had two quiries and just thought if it would
be possible...
But thank you anyway.
Ivan

Brian Jones <bri...@nospam.adroit-software.co.uk> ???Y ?????
???Y??:7n73cj$m...@forums.borland.com...

Quote

> You need two queries. As you have grouped this one, it will always return
a
> sum for each of the grouping conditions. To get a sum of all, create
another
> sql without the group by.

> --
> Adroit Software Ltd
> ------------------------------
> Remove the nospam. to mail me direct
> Ivan wrote in message <7n6qvl$ls...@forums.borland.com>...
> >Hi!
> >I find it interesting is it possible in a query like that

> >SELECT Sum(Price), Id_field
> >WHERE My conditions
> >GROUP BY ...

> >to count not only the sum of Sum(Price), but SUM(Sum(Price)) I mean the
> >total Sum for the aggregate field...
> >And I do think that it might be visual by my DBGrid, so compute by
doesn't
> >seem to be usefull(?).
> >(D4 and SQL 7)
> >Thanks, Ivan

Other Threads

1. Summaries: COUNT, SUM etc.

2. SUM(), AVG(), COUNT()

3. Returning a SUM and COUNT with GROUP BY

4. SQl Functions (sum, count)?

5. SUM COUNT AVERAGE error ?

6. It's not bad canned meat...

7. sum query question

8. calculating sum in query that uses cachedupdates

9. SQL SUM - Query Value out of Bounds

10. connect query SUM() to a DBEdit?