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