Posted by Sjoerd on 04/14/06 13:04

Dejan wrote:
> Now i wanna display all the grad_pbroj coloumns from 'smjestaj', buth not
> displaying duplicates, just to count them, and put the count behind the
> 'grad_pbroj' coloumn.
>
> Result:
> Naziv_first (3)
> Naziv_second (1)
> Naziv_third (8)

Is this what you want?

SELECT first_column, COUNT(*) FROM my_table GROUP BY first_column;

[Back to original message]