Correct Corrupted Gender Data in Employee Table
Filed under TomTom
The question
Write an SQL query using CASE to correct a database where all male and female values in an Employee table's gender column are incorrectly swapped.
No write-up yet. Related questions below have one.
Related TomTom questions
Collected from public candidate posts and coding forums. Updated Nov 2026.