title: Comparing same columns in the same table
body: <p>If I have a data like this in table1</p>
  
  <pre><code>column1 column2 date
  111     00      2016-10-11
  111     00      2016-10-11
  111     20      2016-10-12
  111     20      2016-10-12
  222     00      2016-10-11
  222     20      2016-10-12
  333     20      2016-10-11
  333     20      2016-10-12
  </code></pre>
  
  <p>I want to build a query which picks out only 333 as duplicate because 
  column1 = column1 (333=333), column2 = column2 (20 = 20) and date &lt;> date (2016-10-11 &lt;> 2016-10-12
  Thank you</p>