每个user访问url次数最多的前10条记录
table(user,url)
row = select user from table group by user;
for(i=0;i<sizeof(row);i++)
{
select url,count(url) as a from table where user=row[i] group by url order by a limit 10;
}
table(user,url)
row = select user from table group by user;
for(i=0;i<sizeof(row);i++)
{
select url,count(url) as a from table where user=row[i] group by url order by a limit 10;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货