[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/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
