-
SQL语句求解,按照讨论版id出现的频率从高到低排列出来,并取出最高的前五个值
--讨论版id出现的频率从高到低排列出来select bid,bboard_name,count() as tie_num from bbs_tie a,board b where aboard_id=bid group by bid,
--讨论版id出现的频率从高到低排列出来select bid,bboard_name,count() as tie_num from bbs_tie a,board b where aboard_id=bid group by bid,