Re: fetch row DISTINCT
| From: | jeffrey_n_Dyke at Keane dot com | Date: | Thu, 08 Jul 2004 17:36:09 +0000 |
| Subject: | Re: fetch row DISTINCT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35153@lists.php.net to get a copy of this message | ||
> I'm using PHP with mySQL since a long time.
> But now I got a question:
> I need to generate a SQL-Statement to fetch rows with one DISTINCT
criteria.
> To make things clear: I don't want to fetch a single DISTINCT column, I
want
> to fetch the whole row, where one column is DISTINCT.
> Can someone explain me how to do this?
if i understand correctly this should work
--> select * from table group by distinct_col
hth
jeff
> Kind regards
> Lars Hilsebein
______________________________
<mailto:lars.hilsebein@mockandmore.de>
lars.hilsebein@mockandmore.de
------------------------------
mock&more i-net-solutions(r)
Horstmarer Landweg 107
D-48149 Muenster
Tel. +49 251 14490-200
Durchwahl 14490-201
Fax 14490-240
mobil +49 177 3295900
Mail info@mockandmore.de <mailto:info@mockandmore.de>
==============================