一、根据projectNumber和deviceNumber字段找到重复记录SELECT * from (SELECT *, CONCAT(projectNumber,deviceNumber) as nameAndCode from em_camerainfo) t WHERE t.nameAndCode in&nb...