title: How to display results duplicate rows in the same table?
body: <p>Is it possible to display lines that have duplicates in the same table?<br>
  I tried to make this query on sql developer but it is still searching for a while without giving me results or even error message, here is my last query I tried so far :</p>
  
  <pre><code>SELECT foo.COL_1, foo.COL_2, foo.COL_3, foo.COL_4, foo.COL_5, foo.COL_6, foo.COL_7
  FROM TABLE_NAME foo
  WHERE EXISTS (SELECT bar.COL_1, bar.COL_2, bar.COL_3, bar.COL_4, bar.COL_5, bar.COL_6, bar.COL_7
                FROM TABLE_NAME bar
                WHERE foo.COL_1 = bar.COL_1
                AND foo.COL_2 = bar.COL_2
                AND foo.COL_3 = bar.COL_3
                AND foo.COL_4 = bar.COL_4
                AND foo.COL_5 = bar.COL_5
                AND foo.COL_6 = bar.COL_6
                AND foo.COL_7 = bar.COL_7
                GROUP BY bar.COL_1, bar.COL_2, bar.COL_3, bar.COL_4, bar.COL_5, bar.COL_6, bar.COL_7)
  GROUP BY foo.COL_1, foo.COL_2, foo.COL_3, foo.COL_4, foo.COL_5, foo.COL_6, foo.COL_7
  ORDER BY foo.COL_7
  ;
  </code></pre>
  
  <p><strong>Note :</strong> <br>
  I don't need to see a line with a count that tells me that it exists in 2 or more times, Otherwise I would have put primary key to prevent duplicates. I have to print this data on a report.<br> I will only like the posted ones.<br><br>
  Thank you</p>