Search:

Thanks for the reply. :)
Suppose I am passing the values
emplid : TT20 , effdt : 18/07/2007 and effseq = 0 then i should get
the row corresponding to Emplid :TT20 effdt : 17/07/2007 and effseq =...

Thanks for the reply. :)
Suppose I am passing the values
emplid : TT20 , effdt : 18/07/2007 and effseq = 0 then i should get
the row corresponding to Emplid :TT20 effdt : 17/07/2007 and effseq =...

How do i get the previous row from a table? The table has key fields as emplid (employee ID), Empl_rcd(employement record),effdt and effseq. I can pass all these values from the current row. But...