表结构:
userId , StoreId, comments;
从评价表中选出评价次数超过5的用户的评价次数,并对评价次数按升序排序。
select UserId,count(*) as c from comments group by UserId having c>5 order by c asc;
表结构:
userId , StoreId, comments;
从评价表中选出评价次数超过5的用户的评价次数,并对评价次数按升序排序。
select UserId,count(*) as c from comments group by UserId having c>5 order by c asc;