Record lag functionality in MySQL?

[David L. Van Brunt, Ph.D.]

I have a table of data...


A1 B1 C1
A2 B2 C2

And Iıd like to make a query where I ³lag² a value, grabbing a value from
the next row of the table. Most stat packages have a lag function, but I
canıt find this in MySQL. The end result would look like:

A1 B1 C1 D1 (where ³D1² would equal A2 from above)

Any suggestions?

-- 
David L. Van Brunt, Ph.D.
Outlier Consulting & Development
mailto: <[EMAIL PROTECTED]>