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