title: Calculating Percent Change between two rows
body: <p>I understand that this has been asked already. However, I am relatively new at SQL and MySQL, so I was confused by the other answers.</p>
  
  <p>Say I have a table of historical financial data, and I have multiple records in place.</p>
  
  <pre><code>Date       | Close Price | % Change
  2014-03-25 |    3.58     |   ?
  2014-03-24 |    3.57     |   ?
  2014-03-21 |    3.61     |   ?
  </code></pre>
  
  <p>I have the date and close price in the table. I would like to find the % change from day to day. For example, from 2014-03-24 to 2014-03-25 is about +0.28%.</p>
  
  <p>I'm completely stuck on how to do this for all records without running a large number of individual queries. I'm thinking it's some sort of join, but this is where I'm confused as I have not done these before.</p>