Subject Re: [firebird-support] Need some direction on adding calculations
Author Thomas Steinmaurer
> I am fairly new at using Firebird SQL and I would like some direction on how to include some calculations into my code.
>
> 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.

You haven't told us your tables and possibly a first try of your SQL,
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/