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
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.

  • Attachment: dup_rows.JPG
    (Size: 94.05KB, Downloaded 94 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: 8727
Registered: November 2002
Location: California, USA
Senior Member
Previous Topic: How to put query result into a table
Next Topic: Using upper() function in outerjoin
Goto Forum:

Current Time: Thu Jul 27 23:54:11 CDT 2017

Total time taken to generate the page: 0.55567 seconds