SidimarH

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

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)