Re: Return 1 instance of each unique record?
| From: | Adam Williams | Date: | Fri, 06 Dec 2002 20:27:23 +0000 |
| Subject: | Re: Return 1 instance of each unique record? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23874@lists.php.net to get a copy of this message | ||
use GROUP BY field
Adam
On Fri, 6 Dec 2002, Doug Coning wrote:
> Hi everyone:
>
> How do I get MySQL to summarize a query so that I receive only 1 instance
> per similar record. I.E. if you have 10 records with name "Smith" and 5
> records with "Barney, etc, that it would return 2 records instead of 15.
>
> Thanks!
>
> Doug Coning
>
>
>
>
>