sql 排序

 

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

 

         ViewBag.listImgs = mode.Where(n => n.Column6 == "Image").OrderByDescending(n => n.Orders).ToList();