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();

 

转载于:https://www.cnblogs.com/enych/p/7891785.html