sql help needed

I have a table with about 5 million records in it.  I need to find the unique values of a field called URL and the number of times these specific URLs appear in my table.

For example:

URL               id
----------------------------
www.yahoo.com      1
www.lycos.com      2
www.yahoo.com      3

I need a report for the above data to return:

www.yahoo.com   2
www.lycos.com   1


Thanks!
kmurphy99Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
OlegPConnect With a Mentor Commented:
select url,count(url)
from table
group by url
0
 
OlegPCommented:
With order

select url,count(url)
from table
group by url
order by count(url) desc
0
 
kmurphy99Author Commented:
Thanks!  New to this stuff....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.