if I understand you correctly, this should do it. select distinct office, max(dateposted) from table group by office
On Mon, 2004-07-26 at 23:18, Louie Miranda wrote: > 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 -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
