select count(*) from vote group by contents select count(*) from (select TOP 100 PERCENT * from vote order by contents)as A group by contents select * from vote --统计 1 和 2 和 3 的个数 显示一个表 默认升序 [第一个是最小值的个数] select count(*) from (select * from vote order by contents)as A group by contents
原文：http://www.cnblogs.com/enych/p/7891785.html