[MySQL Lag Function]

 

I had already seen this answer in stack overflow, but I was unsuccessful
https://stackoverflow.com/questions/11303532/simulate-lag-function-in-mysql

[MySQL Lag Function]

Good Morning guys.
I need to use the lag function in MySQL 5, but this function was implemented in version 8 only. 
How can i solve this problem?

-- In MySQL8:

LAG( field,1,0)OVER (PARTITION BY field2 ORDER BY field)