Anand writes "Hi all please help me in my query one recruiter ask me how to do this. here it is what they did ask me:------- there is one table in that table two columns name and gender and the things is that suppose the table is like that
Name Gender Ken M kate F Lucy F Brian M
so please what we have to do write only one single query which we will select all the male from the databse and update them to female and all female to Mail but this should be only in one single query. Not a two query at all ok please help i did use select case but no luck!!! :( please reply to me firstname.lastname@example.org Thanks to whole SQL team."