title: How to avoid duplicate values
body: <p><strong>Table1</strong> </p>
  
  <pre><code>ID  fromdate   todate
  
  001 23/02/2012 27/02/2012
  002 23/02/2012 27/02/2012
  003 28/02/2012 09/09/2013
  ....
  </code></pre>
  
  <p>Condition: I don't want to show duplicate values, so from date validate with other from date, if it's equal then it should not repeat, to date validate with other to date, if it's equal then to date should not repeat, </p>
  
  <p>Expected Output</p>
  
  <pre><code>ID  fromdate   todate
  
  001 23/02/2012 27/02/2012
  003 28/02/2012 09/09/2013
  ....
  </code></pre>
  
  <p>From the above output, 002 is not showing because fromdate and todate is same with 001, so from and to date comparison should not repeat.</p>
  
  <p>How to write a query for the above condition?</p>