title: Sql Query to return only items added this month
body: <p>Im looking for a query that only returns new items for the month. i.e if this item was in last month exclude.</p>
  
  <p>My table looks something like this</p>
  
  <pre><code>Date         fruit    buyer
  2014-04-01   Apple    someone1
  2014-04-01   Banana    someone2
  2014-05-01   Apple    someone2
  2014-05-01   Banana    someone2
  2014-05-01   Pear    someone1
  </code></pre>
  
  <p>So in the case above I want a query that if run for 2014-05-01 would return only apple and pear because either the buyer or the fruit is distinct. but not banana because that exact record was in last month.</p>
  
  <p>I have tried to use a not exists query on itself ie.</p>
  
  <pre><code>select Date, Fruit, buyer
  from table
  where date = 2014-05-01 and not exists(
  select Date, Fruit, buyer
  from table
  where date = 2014-04-01)
  </code></pre>
  
  <p>But this seems to run for a long term and not return the correct results.</p>
  
  <p>I also am aware that one solution would be to normalize buyer out but at the current time is not an option. (is for the long term)</p>
  
  <p>This is on MSSQL.</p>
  
  <p>Thanks in advance</p>