Update "Male" into "Female" and "Female" into "Male" in Gender Column of a table in single line query.?
Vishwajeet Jha
update table_Name set Gender= Case when Gender='Male' then 'Female' else'Male' end
Update table_name set Gender= case when Gender='Female' then 'Male' when Gender='Male' then 'Female' end where Gender in('Female','Male')