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]>


Reply via email to