没脾气2x · 2007-05-19 21:03:54 · 阅读: 238 很简单的呃 SELECT substring(smark,1,1) , COUNT(*) FROM table GROUP by substring(smark,1,1)