统计代码（group by ,count ）

select left(strMobileNo,4),count( strMobileNo)
 from no_kldby_userinfo
 where dteRegTime >= '2006-08-14 00:00:00'
        group by left(strMobileNo ,4)