Posted by Dejan on 04/14/06 21:45

Yeah, i know that, buth i have left join...order by ... group by.

And i have sql syntax error, and don't know how to display related coloumn,
and number of duplicates.


Sjoerd <sjoerder@gmail.com> wrote in message
news:1145009057.659424.240850@u72g2000cwu.googlegroups.com...
> 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]