SQL Query By Group

[NZ_Kiwis]

I want to do a SQL query and display the results... this is my DB

ID - Page_ID
1 - 6
2 - 6
3 - 7
4 - 1
5 - 6
5 - 1

i want it to loop over and over and display the results like this

Page ID 6 = 3 times
Page_ID 7 = 1
Page_ID 1 = 2 times

how can this be done?

[bpat1434]

SELECT COUNT(Page_ID), Page_ID
FROM table
GROUP BY Page_ID
ORDER BY Page_ID ASC