RE: [PHP-DB] Select distinct field won't return distinct value
| From: | Blanton, Bob | Date: | Wed, 07 Jun 2006 04:36:28 +0000 |
| Subject: | RE: [PHP-DB] Select distinct field won't return distinct value | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42011@lists.php.net to get a copy of this message | ||
It is a Sybase vendor function but I was wondering if mysql had
something comparable. I don't see anything in the manual. Maybe the
subquery is the only way to go.
-----Original Message-----
From: Chris [mailto:dmagick@gmail.com]
Sent: Wednesday, June 07, 2006 8:50 AM
To: Blanton, Bob
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Select distinct field won't return distinct value
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 2207
Pretty sure that's a sybase specific function. Nothing like that exists
in mysql or postgresql.
--
Postgresql & php tutorials
http://www.designmagick.com/