@
Currently I'm testing a partcular col which is loaded with the help of etl and I need to compare that my sql query.
now my issue is the logic whihc I should test is that:
cola - Set to the colb of the previous row in this table for the given id. This would be date - 1.
My question is how to incorporate this in my select query:
select query to assign a cola's prevoius month last date value to colb
Please advice .
Message was edited by: 84864a31-e269-47e7-87a7-42a8456cf73d