select author,count(*)
from pre_forum_thread
WHERE dateline > 1404144000 and dateline < 1406822399
group by author
having count(*)>1
注意WHERE必须在 group by 之前。
from pre_forum_thread
WHERE dateline > 1404144000 and dateline < 1406822399
group by author
having count(*)>1
注意WHERE必须在 group by 之前。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货