select a.*,b.topic_author
from(
select reply_topic_id ,[count]=COUNT(topic_id),topic_time=MAX(topic_time)
from topic
Group By reply_topic_id
)a,topic b
where a.reply_topic_id=b.reply_topic_id
and a.topic_time=b.topic_time
from(
select reply_topic_id ,[count]=COUNT(topic_id),topic_time=MAX(topic_time)
from topic
Group By reply_topic_id
)a,topic b
where a.reply_topic_id=b.reply_topic_id
and a.topic_time=b.topic_time
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货