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