Linq 独特的 &最大限度

I need one row for all distinct symbols having the biggest time value. How do I have to write my linq query?

提前致谢，

推荐答案

按符号对行进行分组，然后从每个最大时间(表 是上下文中的数据库表名):

Group rows by symbol and then select from each group item with max time (Table is your database table name from context):

from r in Table
group r by r.symbol into g
select g.OrderByDescending(x => x.time).First()

与方法语法相同:

Table.GroupBy(r => r.symbol)
     .Select(g => g.OrderByDescending(x => x.time).First());

这篇关于Linq 独特的 &最大限度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！