Subject | Re: [firebird-support] Need some direction on adding calculations |
---|---|
Author | Thomas Steinmaurer |
Post date | 2013-02-06T18:45:24Z |
> I am fairly new at using Firebird SQL and I would like some direction on how to include some calculations into my code.You haven't told us your tables and possibly a first try of your SQL,
>
> For example I want to read a table, group by a part number and then get a total price for all the items in the group. Would this be something for a SP?
>
> I have looked online but couldn't find a complete answer.
but the following might put you into the right direction.
select
part_number
, sum(prize)
from
yourtable
group by
part_number
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/