SELECT `url`, count(*) as `n`
FROM `table_name`
GROUP BY `url`
HAVING `n` > 1
ORDER BY `n` DESC
This entry was posted
on Tuesday, April 7th, 2009 at 11:07 and is filed under SQL.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.