Re: sum of a column (development question)
- From: "David Sharples" <davidsharples@xxxxxxxxx>
- To: lyallbarbour@xxxxxxxxxxxxxxx
- Date: Tue, 11 Sep 2007 19:37:19 +0100
group the records by year and filter it by the two years you want
select year, sum(total) where year in xxx group by year
On 11/09/2007, Lyall Barbour <lyallbarbour@xxxxxxxxxxxxxxx> wrote:
>
> Hi again,
> Development question. User wants the sum of all the purchase orders
> for this year and last year. I'm trying to get it in the same select
> statement. I want something like this, but don't know how to get it.
>
Other related posts:
