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