select count(*) from SMARTSTG.PROMOTIONU;
select count(*) from (select distinct * from SMARTSTG.PROMOTIONU);
select * from SMARTSTG.PROMOTIONU a
where (a.MUNMBR,a.MULINE) in (select MUNMBR,MULINE from SMARTSTG.PROMOTIONU group by MUNMBR,MULINE having count(*) > 1);
select rowid,MUNMBR,MULINE from SMARTSTG.PROMOTIONU a
where (a.MUNMBR,a.MULINE) in (select MUNMBR,MULINE from SMARTSTG.PROMOTIONU group by MUNMBR,MULINE having count(*) > 1)
and rowid not in (select min(rowid) from SMARTSTG.PROMOTIONU group by MUNMBR,MULINE having count(*)>1);
select count(*) from (select distinct * from SMARTSTG.PROMOTIONU);
select * from SMARTSTG.PROMOTIONU a
where (a.MUNMBR,a.MULINE) in (select MUNMBR,MULINE from SMARTSTG.PROMOTIONU group by MUNMBR,MULINE having count(*) > 1);
select rowid,MUNMBR,MULINE from SMARTSTG.PROMOTIONU a
where (a.MUNMBR,a.MULINE) in (select MUNMBR,MULINE from SMARTSTG.PROMOTIONU group by MUNMBR,MULINE having count(*) > 1)
and rowid not in (select min(rowid) from SMARTSTG.PROMOTIONU group by MUNMBR,MULINE having count(*)>1);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11976525/viewspace-701752/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 一个抽取outlook邮件信息的VBA script
- ORA-00600: [kkocxj : pjpCtx]
- ORA-00600: : [rworupo.1], [30], [24]
- ORA-00600: internal error code, arguments: [kxfpg1sg:INV],
- 一次因临时表空间问题而导致的RAC节点failover
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- ASM
- ORA-02396: exceeded maximum idle time, please connect again .
- oracle 内存分配之最细粒度granule
- ORA-04031: unable to allocate 3896 bytes of shared memory
