SQL查询重复记录

select * from list where callnumber in (select callnumber from list where group by callnumber having(count(*))>1) order by callnumber