我目前正在尝试为我的网站获取一些统计数据,但我似乎无法为我的数据库创建查询来获取用户名,如果在所有行中找到最频繁的用户名。
sql查询应如下所示:
SELECT username FROM Views GROUP BY 'username' ORDER BY COUNT(*) DESC LIMIT 1如何在我控制器中进行查询?
发布于 2011-06-23 20:03:54
var username = db.Views.GroupBy(v => v.username).OrderByDescending(g => g.Count()).First().Key发布于 2011-06-23 20:05:00
(from a in Views
group a by a.username into b
let c = b.count()
orderby c descending
select a.username).take(1);您的查询转换.....
发布于 2011-06-23 20:04:43
这就是如何使用LINQ执行查询:
var temp = (from a in Views
group a.username by a.username into b
orderby b.Count() descending
select b.Key).Take(1);https://stackoverflow.com/questions/6453594
复制相似问题