蓝狐的技术思考 BlueFox Thinking in Tech...
交流,分享,探讨技术...... Communication, Sharing, and Discussion about Technology.....

导航

 

2009年8月4日

摘要: 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 蓝狐 阅读(163) 评论(0) 推荐(0) 编辑