查找不重复记录

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