2 Replies Latest reply: Aug 25, 2014 12:16 PM by rp0428 RSS

    i'm doing ETL testing with the help of sql and I have question on how to wrtie a  select query to assign a cola's prevoius month last date value to colb

    84864a31-e269-47e7-87a7-42a8456cf73d

      @

      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