title: Select all where date in Last month sql
body: <p>How can I get last month date like </p>
  
  <pre><code>select * from table where date in ( last month  )
  </code></pre>
  
  <p>I dont want the last 30 days 
  AND how can I get last month automatically </p>