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
sql 排序
标签:count 第一个 span 显示 bsp pre 最小 top content