Table has 3 columns,Name,year,count and I need a total of the
for each name over a 3 yr period, if there are NOT 3 years available
then no
output row.

Project approved. Please proceed.

I guess I should explain my prior response. I saw this same problem
(perhaps even with the same sample data - which if you look closely is 15
years old - when I was taking an SQL class way back when.

I solved that problem myself. I didn't send it to some list of experts
saying, "Here's my homework; do it for me." And it is disappointing to see
others use this community of anxious-to-help individuals so selfishly.
Also, didn't this problem hit this same list a few weeks back, or am I
thinking of another list? Yeah, I realize I'm probably not going to change
the world. But that won't stop me trying.

Dennis Lovelady
"Jerry died broke. We only have a few hundred thousand dollars in the
-- Debora Koons Garcia, widow of The Grateful Dead's Jerry Garcia

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].