MySQL Lag Function

[SidimarH]

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) 

 

[Patropi]

 

This is my favorite MySQL hack.

This is how you emulate the lag function:

SET @quot=-1; select time,company,@quot lag_quote, @quot:=quote curr_quote from stocks order by company,time;

lag_quote holds the value of previous row's quote. For the first row @quot is -1.

curr_quote holds the value of current row's quote.

[SidimarH]

 

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