Re: select * on all current?
| From: | Louie Miranda | Date: | Tue, 27 Jul 2004 06:43:58 +0000 |
| Subject: | Re: select * on all current? | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-191942@lists.php.net to get a copy of this message | ||
ok, just removed the distinct syntax
On Mon, 26 Jul 2004 23:51:43 -0500, mos <mos99@fastmail.fm> wrote:
> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=lmiranda@gmail.com
>
>
--
Louie Miranda
http://www.axishift.com