MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:mos Date:July 27 2004 4:51am
Subject:Re: select * on all current?
View as plain text  
At 10:45 PM 7/26/2004, you wrote:
>if I understand you correctly, this should do it.
>
>select distinct office, max(dateposted)
>from table
>group by office


Just one more thing. You don't need "distinct" because you are already 
using "group by".

Mike

Thread
select * on all current?Louie Miranda27 Jul
  • Re: select * on all current?Louie Miranda27 Jul
    • Re: select * on all current?Michael Dykman27 Jul
      • Re: select * on all current?mos27 Jul