取第一条数据的几种写法

最新推荐文章于 2022-04-07 15:30:33 发布

weixin_30906671

最新推荐文章于 2022-04-07 15:30:33 发布

阅读量503

点赞数

文章标签：数据库 json

原文链接：http://www.cnblogs.com/kongxiaoshuang/p/6669845.html

版权

SQL

SELECT  *
FROM    ( SELECT    * ,
                    r = ROW_NUMBER() OVER ( PARTITION BY MobilePhone ORDER BY MobilePhone )
          FROM      dbo.v_candidates
        ) t
WHERE   t.r = 1

LINQ

class Student
{
   public string Name { get; set; }
   public int Score { get; set; }
}
List<Student> students = new List<Student>{
               new Student {Name="Terry", Score=50},          
               new Student {Name="Tom", Score=85},
               new Student {Name="Wade", Score=90},
               new Student {Name="James", Score=70},
               new Student {Name="Kobe", Score=90},
               new Student {Name="AK", Score=90}             
};

var query = from student in students
            orderby student.Score descending, student.Name
            select student;

var model=query.Where(m=>m.Name=='Tom').FirstOrDefault();
if(model!=null){
  //数据处理
}