I want to exchange value of specific record and the one precede it , I can do that using two update sql of course but I just wonder if it can be done in one sql.

Thanks