08 2009 档案

• 查找不重复记录
  摘要：1.查找不重复记录例：ORGAN_ID列没有重复，Enterpriseid有重复记录，查找出Enterpriseid不重复的记录SELECT *FROM BPI_ORGANWHERE (ORGAN_ID IN (SELECT MIN(ORGAN_ID) FROM BPI_ORGan GROUP BY Enterpriseid)) 阅读全文
  posted @ 2009-08-04 14:28 蓝狐 阅读(171) 评论(0) 推荐(0)