MySQL: Self join table offset by one row (equiv to T-SQL CTE with ROW_NUMBER())
<p>As the title suggests, in <strong>MySQL</strong>, I want to join a table to itself, offset by 1 row so that I can calculate the time between rows for DateTime fields.</p>

<p>In T-SQL this would be done using ROW_NUMBER() and CTE.</p>