title: SQL Datediff - find datediff between rows
body: <p>I would like to query a database using sql to show the difference in time between id 1,2,3 and so on. basically it will compare the row below it for all records. any help would be appreciated. </p>
  
  <pre><code>IDCODE  DATE TIME        DIFFERENCE (MINS)
  1      02/03/2011 08:00        0
  2      02/03/2011 08:10        10
  3      02/03/2011 08:23        13
  4       02/03/2011 08:25        2
  5       02/03/2011 09:25        60
  6       02/03/2011 10:20        55
  7       02/03/2011 10:34        14
  </code></pre>
  
  <p>Thanks!</p>