title: minus operator in oracle for the same table
body: <p>I am trying to use minus operator to the same table to show duplicate records by using distinct key word in the second query but the query result was no rows selected.so So what is the explanation of this ?</p>
  
  <p>select column1 from my_table
  minus
  select distinct(column1) from my_table;</p>