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 under one effdt there can be more than one effseq. A sample of the data
Emplid Empl_rcd Effdt Effseq
TT20 15 18/07/07 0
TT20 15 17/07/07 2
TT20 15 17/07/07 1
TT20 15 17/07/07 0