|
|
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;
Navigation:
[Reply to this message]
|