mysql analytic function?

Question

MySQL

Question: Does MySQL support displaying the previous and next row from the selected one?
The forums say that MySQL does not support analytic functions. The MySQL documentation provides the LAG() and LEAD() functions.
How to implement these functions, show a simple example?

Answer 1

About: LAG(
) I didn't look for LEAD()...