Eh, he's off topic, but we've talked plenty SQL on here before...

SELECT num, COUNT( num ) FROM table GROUP BY num;

I don't have a myqsl server to test that, but should do it.

-- 
-Dan Joseph

www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month.  Promo
Code "NEWTHINGS" for 10% off initial order

http://www.facebook.com/canishosting
http://www.facebook.com/originalpoetry

Reply via email to