Update Male TO Female and Female To Male with single query

UPDATE    employee
SET             
gender = CASE gender WHEN 'male' THEN 'female' WHEN 'female' THEN 'male'
ELSE gender
END
Ebook Download
View all
Learn
View all