True. I didn't notice that he wanted more than just the latest back. Why
not use an order by with a limit of 1? If you use ASC or DESC you can
determine the first or the last.
On Thu, 29 Apr 1999, Fred Read wrote:
> Fraser MacKenzie wrote:
> > Sure you can do this. I do it all the time. Here is the select
> > select MAX(latest) from MyTable where username='MyUsername';
> Ok, but the question was;
> "How do I return the most recent row for a given xxx?"
> With your solution I would have to do two selects;
> 1. Find Max(Date) for UserName
> 2. Select row for UserName AND [previously found] Max(Date)
> This is not an atomic operation so unless tables are locked,
> could result in data inconsistencies...
> If it ain't opinionated, it ain't Rich Teer.