Is it also possible to use this? http://dev.mysql.com/doc/mysql/en/example-Maximum-row.html
SELECT MAX(dateposted) FROM table; But instead do select all max(dateposted) on office? have tried it, but syntax errors occured. On Tue, 27 Jul 2004 11:13:43 +0800, Louie Miranda <[EMAIL PROTECTED]> wrote: > I have a couple of fields: > > - office > - dateposted > - filename > > now, im having trouble selecting all current "dateposted" per office? > > i have tried.. > > sql> select * from datafiles where dateposted current(); > > And i think its wrong, i could not find how to get it. > > -- > Louie Miranda > http://www.axishift.com > -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
