sql of no of count in a value

select mobile,count(mobile) from table group by mobile

This will return no of counts for a mobile number.