Matching all values in NOT IN clause
<p>Is there a way to ensure all values in an NOT IN clause are matched?</p>

<p>Example:</p>

<p>I have a table DateValue with 2 columns Date and Value</p>

<pre><code>ID========  DATE   ============VALUE
1========2015-01-01=========== 12
2========2015-01-01=========== 13
3========2015-01-01=========== 15
4========2015-01-01=========== 16
5========2015-01-02========== 15
6========2015-01-04=========== 15
7========2015-01-05=========== 16
8========2015-01-06=========== 12
9========2015-01-06=========== 13
10========2015-01-06=========== 15
</code></pre>

<p>How I select all row where VALUE not = 12, 13 and 15 in same day</p>

<p>=> That mean I will return:</p>

<pre><code>5========2015-01-02========== 15
6========2015-01-04=========== 15
7========2015-01-05=========== 16
</code></pre>