Posted by Arjen on 04/13/06 13:32

Dejan wrote:
> Hi
>
> First sorry for my terreble english
>
> I have mysql table like this:
>
> id | name
> ---------------------
> 1 | Ivan
> 2 | John
> 3 | John
>
> Now i wanna display it on web page like this
>
> Ivan (1)
> John (2)
>
> Selecting duplicates, buth only showing number of duplicates..

SELECT COUNT (id) GROUP BY name

Arjen

[Back to original message]