haitao: 这个好像是很基本的查询。。。。。。 [阅读: 325] 2007-05-19 12:49:28 select left(sMark,1) as f1,count(*) as f2 from tb group by left(sMark,1)