Page 1 of 1

selecting a top of ocorrences in a table

Posted: Fri Sep 22, 2006 12:05 pm
by pedrotuga
I have the referers to my site in a table and I want to view a top of the linking-in sites. the tables has both the domain and the complete referer.

This should be like the question asked a 1000 times, buti couldnt find anything similar using the search.

How do i get a top of the domains linking in? any hints on the sql code?

like

google.com
677 hits

yahoo.com
100 hits

blaba.co.uk
20 hits

Posted: Fri Sep 22, 2006 12:09 pm
by feyd
GROUP BY clause.

Posted: Sat Sep 23, 2006 3:12 pm
by pedrotuga
yep... this was stupid of me... group by, of course!

thank you