select * from t_contract t where t.contractid in (select contractid from t_contract
group by contractid having count(1)>1) and t.companyid='****' order by t.contractid desc, t.id desc;
查询表t_contract中,所有contractid字段内容重复的数据,并把数据按照先按照contractid,再按照id 降序排列展示出来。
更加精简一点,可以将语句改成:
select * from t_contract t where (select count(*) from t_contract s where s.contractid=t.contractid)>1