×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Table has 3 columns,Name,year,count and I need a total of the
"count"
field
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
http://www.linkedin.com/in/dennislovelady
--
"Jerry died broke. We only have a few hundred thousand dollars in the
bank."
-- Debora Koons Garcia, widow of The Grateful Dead's Jerry Garcia
This mailing list archive is Copyright 1997-2024 by midrange.com 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
