Kurt Welgehausen wrote:
I want the title, the MAX(speed) for each title group, and the date
that occurred. In case, ...
I haven't tried this, but I think it's correct. Let me
know if it's not.
select distinct table.title, table.date, t2.maxsp
from table,
(select title ttl, max(speed) maxsp from table group by ttl) t2
where table.title = t2.ttl and table.speed = t2.maxsp
thanks Kurt... a slight tweak on your suggestion, and I get the desired
results from the following
SELECT t.title, t.date, t.speed
FROM table t JOIN (
SELECT title, MAX(speed) maxsp
FROM table
GROUP BY title) t2 ON t.title = t2.title
WHERE t.speed = t2.maxsp
ORDER BY t.title
Couldn't have done without your suggestion. Here's a virtual 22 oz. of
cold, local Wisconsin beer to you.
