ht · 2007-05-19 20:46:11 · 阅读: 282 ==> Select a,count(*) from select left(SMark,1) as a from Table T1 group by a