limit results to an aggregate function total

[bebblebrox]

Hi,

My table (gift_history) looks like this:

donor_id number
gift_date datetime
gift_amount number

query looks like this:

select donor_id 
from gift_history 
where donor_id= 3890 And gift_date between '01/01/1991' and '01/01/1992' 
group by donor_id having sum(gift_amount) between 15 and 460

which returns 1 result, 3890

now donor 3890 does in fact have otal gifts from 1976 to 2006 of $450. However, what I need the query to return is donors who have gifts totalling between 15 and 460 only in 1991.

what do i need to change?

thanks!

 

[bborissov]

select donor_id
from gift_history
where donor_id= 3890 And
      YEAR(gift_date)= 1991
group by donor_id, YEAR(gift_date)
having sum(gift_amount) between 15 and 460

Borislav Borissov

 

[gmmastros]

select donor_id 
from   gift_history 
where  donor_id= 3890 
       And gift_date between '01/01/1991' and '01/01/1992' 
group by donor_id 
having sum(gift_amount) between 15 and 460
[!]       And gift_date between '01/01/1991' and '01/01/1992' [/!]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Nagrom]

If you want all donors meeting that criteria then you need to take out the "donor_id= 3890" part - otherwise that's the only donor you'll ever get.

 

[bebblebrox]

thanks guys...my sql is a little rusty.

nagorm...i had the donor id critera on purpose to limit the results to a particular donor for testing.