Find all duplicates in table

//uniqueid is columns with duplicate
select count(uniqueid) as t,uniqueID from companydetails group by
uniqueid having count(uniqueid)>1 order by t desc