62,073
社区成员
发帖
与我相关
我的任务
分享
SELECT ClmID, MAX(CPDate) FROM tb_ClaimProcces
WHERE (CPDate > '2009-01-05')
GROUP BY ClmID
SELECT ClmID, MAX(CPDate) FROM tb_ClaimProcces
WHERE (CPDate > '2009-04-05')
GROUP BY ClmID
foreach (var t in query)
{
tb_ClainProcea = new tb_ClainProce();
a.ClmId = t.ClmId;
a.CpDate = t.MaxDate;
myCollection.Add(a);
}
var query = from t in db.tb_ClainProces
where t.CpDate >= new DateTime(2009, 1, 5)
group t by t.ClmId into g
select new
{
ClmId = g.Max(p => p.ClmId),
MaxDate = g.Max(p => p.CpDate)
};
List<tb_ClainProce> myCollection = new List<tb_ClainProce>();
foreach (tb_ClainProce t in db.tb_ClainProces)
{
myCollection.Add(t);
}