CM:
SELECT * FROM MyTable WHERE GroupID = '10' AND Service_Date =
( SELECT MAX(Service_Date) FROM MyTable WHERE GroupID = '10' )
Is that the best way to go about this? The typical solution is
I've posted a couple times on this sort of thing.
Here's a discussion.
Also, if two records have identical dates, I'll get two records back. I don't know that I'd really want to get them both back. Well, you'd have that exact same issue if you were qualifying on a specific date (where m.Service_Date = '20-JAN-2005', for example), so the issue of multiple rows returned for a given date is independent of the issue of finding the maximum date across an arbitrary grouping.