110,533
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP(10) ip, COUNT(DISTINCT userid) FROM login_log
GROUP BY IP
var Data = (from t in db.login_log
group t by new
{
ip = t.ip
} into g
select new
{
ip = g.Key.ip,
count = ((from p in db.login_log where p.ip == g.Key.ip select p.userid).Distinct().Count())
}).ToList();
SELECT ip, COUNT(DISTINCT userid) FROM login_log
GROUP BY IP
我原来的语句已经实现,只是这个方法有些笨, 就是想找个比这个效率更好的语句
var data = from t in db.login_log
group t by new
{
ip = t.ip
} into g
select new
{
ip = g.Key.ip,
count = ((from p in db.login_log where p.ip == g.Key.ip select p.userid).Distinct().Count())
}