title: SQL Query to only pull one record for first day of month, for every month
body: <p>I have a table that has one record per day. E.g. (this is just the date col of the table)</p>
  
  <pre><code>2018-07-08 03:00:00
  2018-07-07 03:00:00
  2018-07-06 03:00:00
  2018-07-05 03:00:00
  2018-07-04 03:00:00
  2018-07-03 03:00:00
  2018-07-02 03:00:00
  2018-07-01 03:00:00
  2018-06-30 03:00:00
  2018-06-29 03:00:00
  </code></pre>
  
  <p>This data goes back a few years</p>
  
  <p>I want to pull just the first day of month record, for all months in the table.</p>
  
  <p>What is the SQL to do that?</p>
  
  <p>(On SQL Server 2014)</p>