Posted by Jerry Stuckle on 04/14/06 23:40

Dejan wrote:
> 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;
>>
>
>
>

Well, post your attempt(s) and maybe we can see what's wrong!

Sjoerd showed you how to do it. We can't do much more with the information
you've provided.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]