Re: Select distinct field won't return distinct value
| From: | Chris | Date: | Wed, 07 Jun 2006 04:19:49 +0000 |
| Subject: | Re: Select distinct field won't return distinct value | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42010@lists.php.net to get a copy of this message | ||
Blanton, Bob wrote:
I'm just learning MySQL so don't know all the syntax. There is a "LIST" function in Sybase Adaptive Server Anywhere which would do that. Is there an equivalent function in MySQL? Query: SELECT distinct niin, list(serial_number) FROM fmds.maintenance_equipment group by niin order by niin Output: niin list(serial_number) 000213909 B71-11649,B71-11657,B71-11650 000473750 BAF-3750-0001,BAF-3750-0002,BAF-3750-0003 000929062 2341 001139768 2207Pretty sure that's a sybase specific function. Nothing like that exists in mysql or postgresql. -- Postgresql & php tutorials http://www.designmagick.com/