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