haitao · 2005-08-02 03:15:31 · 阅读: 614 order by count()倒是没有用过。。。这样行不行 select * from ( select post_comment_id,count(*) as fc from comment group by post_comment_id ) a order by fc desc