I have no problem as such with the following query but I was just wondering if there was any better way to write this...

update mwebSubledger set Subledger_Type = 2
where subledger_id = (Select max(subledger_id)
from mwebSubledger
where subledger_work_id=inworkid
and subledger_acct_number=58009
and subledger_theatre=intheatre
and subledger_partner_ID=inpartner
and subledger_id< (Select max(subledger_id)
from mwebSubledger
where subledger_work_id=inworkid
and subledger_acct_number=58009
and subledger_theatre=intheatre
and subledger_partner_ID=inpartner));

I want to update the previous record !

Thanks
Sonali