The issue here is that MAX is not a single record, it could be 5 records with the same date, it could be 5000 records with the same date.
-Thadeus On Mon, Feb 15, 2010 at 5:08 PM, Tiago Almeida <tiago.b.alme...@gmail.com> wrote: > Can't you sort by day and get the first? > I don't know if max exists. > Regards, > Tiago > On Mon, Feb 15, 2010 at 10:49 PM, baloan <balo...@googlemail.com> wrote: >> >> Now I'm trying to do >> >> SELECT MAX(DAY) FROM T WHERE DAY < '2007-12-04' >> >> and I fail to find an operator for "MAX" in the web2py book. Is it >> supported? >> >> Regards, Andreas >> >> >> PS: The online book is splendid. I like it. Much easier to work with. >> Now web2py is a truly "free" application. >> >> Note: In section 6.5 the paragraph on "Logical Operators" has some >> typos at the operators (&~). >> >> -- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To post to this group, send email to web...@googlegroups.com. >> To unsubscribe from this group, send email to >> web2py+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/web2py?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
