查找不重复记录 1.查找不重复记录 例:ORGAN_ID列没有重复,Enterpriseid有重复记录,查找出Enterpriseid不重复的记录 SELECT * FROM BPI_ORGAN WHERE (ORGAN_ID IN (SELECT MIN(ORGAN_ID) FROM BPI_ORGan GROUP BY Enterpriseid))