title: Display value from previous month SQL
body: <p><a href="https://i.stack.imgur.com/gdOXh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gdOXh.png" alt="enter image description here"></a></p>
  
  <p>Hi,
  I have columns as above. How to create select that in column "prev value" will display "value" from previous reporting date (previous month)?</p>
  
  <pre><code>select id, name, name2, value, 
  (
  select value from bi_date as b2 
  where b1.month(reporting_date) = (b2.month(reporting_date)-1)
  ) as prev_value
  
  from table1 as b1
  </code></pre>