2017年7月14日

oracle 查询重复内容

摘要: select VENDOR_NAME,count(distinct VENDOR_MDM_CODE) from I_INQUIRY_VENDOR_LIST where 1=1 group by VENDOR_NAME having count(distinct VENDOR_MDM_CODE)>1 select * from (select t1.entity_name,count(t1... 阅读全文

posted @ 2017-07-14 17:14 逊王之王 阅读(188) 评论(0) 推荐(0) 编辑

导航