Re: Exclude indentical values
| From: | Hugh Bothwell | Date: | Sat, 20 Apr 2002 18:57:37 +0000 |
| Subject: | Re: Exclude indentical values | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18700@lists.php.net to get a copy of this message | ||
SELECT BlaID, MAX(BlaInfo) AS Info
FROM mytable GROUP BY BlaId
"Prodoc" <abosma@hotpop.com> wrote in message
news:3CC18847.7010509@hotpop.com...
> ok, sorry about that :-)
>
> Table:
> BlaID
> BlaInfo
> 20
> 4
> 17
> 8
> 20
> 9
> 15
> 81
> 20
> 12
> 20 23
> 17
> 0
>
> Result:
> BlaID
> BlaInfo
> 15
> 81
> 17 0
> 20
> 9
>
> I don't realy care about the value's I get in BlaInfo as long as I get
> one of those value's...
> I asume this is a very simple instruction but I just started using
> php+mysql so I don't know the propper words I could use to do a search :-)