LAG() function:#PostgreSQL LAG() function provides access to a row that comes before the current row at a specified physical offset. In other words, from the current row the LAG() function can access data of the previous row, or the row before the previous row, and so on.
The LAG() function will be very useful for comparing the values of the current and the previous row.
more info…
@javaCode☕️
