mysql query trouble
Posted
by Bharanikumar
on Stack Overflow
See other posts from Stack Overflow
or by Bharanikumar
Published on 2010-05-04T07:14:58Z
Indexed on
2010/05/04
7:28 UTC
Read the original article
Hit count: 147
mysql-query
Hi ,
in my database i have phone numbers with country code , which look somthing like
0044-123456
0044-123456
0014-123456
0014-123456
0024-123456
0024-123456
0034-123456
0044-123456
0044-123456
0024-123456
0034-123456
084-123456
084-123456
i want to total up the numbers by country, something like this output
0044 (2)
0024 (2)
0034 (1)
084 (2)
064 (5)
Is it possible to do this with a SQL query?
© Stack Overflow or respective owner