给定表为:
Postcode _______SuburbName
一一一一一一一一一一一一一一一一一一
3011 ____________Footscray
3045____________Asco
3088____________Highpoint
.........
一一一一一一一一一一一一一一一一一一一
答案可能是:
A 3
B 6
.........
Z 4
一一一一一一一一一一一一一
,只是跳过字母为零.....
非常感谢您的时间:(
使用左图提取第一个字母,计算以了解有多少字母,然后对每个字母进行计数:
SELECT LEFT(SuburbName, 1) AS letter, COUNT(*) AS nb
FROM my_table
GROUP BY letter