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) 编辑