记下这个例子，查找字段相同的语句

select * from cdb_posts group by pid HAVING COUNT(*)>1 order by tid desc