Suppose i have a table emp with following field name firstname, lastname, salary, age and dept. there is a mistake made while typing names inplace of firstname lastname has been filled and inplace of lastname firstname has been filled. How can we rectify this using a single update query.