title: SELECT previous year up to current date
body: <p>I have a table which has a Start Date column for example:</p>
  
  <pre><code>Start Date
  2015/01/05
  2015/02/08
  2016/01/10
  2017/02/10
  etc...
  </code></pre>
  
  <p>I am trying to put into my <code>WHERE</code> clause to select all records where it is one year prior based on the current <code>GETDATE()</code>.</p>
  
  <p>For example, if today is July 2019 and I run the query, I'd like for it to run and give me Start Dates starting from July of 2018 up until June of 2019. And if I run it for August of 2019, I'd like for it to show Start Dates from August of 2018 up until July of 2019, and so on. Basically up until the month before of the current date.</p>
  
  <p>Currently I have this in my <code>WHERE</code> clause:</p>
  
  <pre><code>WHERE start_date between DATEADD(YEAR,-1, GETDATE()) and GETDATE()
  </code></pre>
  
  <p>but this appears I believe to get just one year prior up until the current date exact.</p>
  
  <p>Is there a better way for me to do this?</p>