[Top-posting fixed]
On Fri, Nov 12, 2004 at 09:06:08AM -0500, Goutam Paruchuri wrote:
> Scott Frankel wrote:
>
> > ORDER BY DESC LIMIT 1 is much simpler and more readable than a
> > sub-query. Though the sub-query approach looks to be a good template
> > for ensuring more accurate results by being more explicit.
Scott, how would a subquery "ensure more accurate results by being
more explicit"?
> If 2 days are equal for color red, you still would get 2 rows returned.
How do you figure, given the presence of LIMIT 1?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/