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.
Fraser
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.
>
