Home » SQL & PL/SQL » SQL & PL/SQL » retrieve duplicate rows from a query result (Oracle 10g)
retrieve duplicate rows from a query result [message #321594] Tue, 20 May 2008 15:55 Go to next message
dk31
Messages: 2
Registered: May 2008
Junior Member
Hi All,

Is it possible to retrieve duplicate rows from a query result.

select a.wrk_inst, a.type_cd, a.idno, a.idno_wop, a.valid, a.sort
from CCC_WORK_idno a, temp_deepti_wrk_insts b
where a.WRK_INST=b.WRK_INST and a.TYPE_CD ='B'

The outpuit of this query has some duplicate rows.
I want to retrieve only those duplicate rows.
Attached the query result highlighted with duplicate rows.

Please let me know how to do that.

Thanks
  • Attachment: dup_rows.JPG
    (Size: 94.05KB, Downloaded 91 times)
Re: retrieve duplicate rows from a query result [message #321598 is a reply to message #321594] Tue, 20 May 2008 16:05 Go to previous message
Barbara Boehmer
Messages: 8631
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1297601868781
Previous Topic: How to put query result into a table
Next Topic: Using upper() function in outerjoin
Goto Forum:
  


Current Time: Mon Dec 05 09:17:22 CST 2016

Total time taken to generate the page: 0.07622 seconds