haitao · 2007-05-19 12:55:13 · 阅读: 302 需要括号 Select a,count(*) from (select left(SMark,1) as a from Table) T1 group by a