Comparing same columns in the same table
<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>