SELECT Top 20 count(ThreadID) as 'count', Subject,
min(date),'至',max(date)
FROM post
group by ThreadID, Subject
order by count(ThreadID) desc
可以吗?
min(date),'至',max(date)
FROM post
group by ThreadID, Subject
order by count(ThreadID) desc
可以吗?
i'll close this post now.