Re: Select most recent row - another one for the FAQ perhaps?

[Fred Read]

Robin Bowes wrote:
> 
> Fred Read wrote:
> >     "How do I return the most recent row for a given xxx?"
> 
> Try
> 
>      select
>          UserName, Created, Latest
>      from
>          MyTable
>      where
>          Latest = max(Latest);
>      and
>          UserName = 'MyUserName'

That couldn't work because Latest is not a column [see table 
definition] it is an alias for a calculated value [see SQL]. 
-- 

If it ain't opinionated, it ain't Rich Teer.