JobsJob TrackerJob alerts

TomTom ยท 9 questions

All 9Coding 8
  • Array Index Traversal and Perfect Squares CountCoding
  • Optimize Array Traversal and Distinct Pair DifferenceCoding
  • Write JSON for Empty Object and Employee Object
  • Correct Corrupted Gender Data in Employee TableCoding
  • Largest Sum Contiguous SubarrayCoding
  • Find duplicates in O(n) time and O(1) extra spaceCoding
  • Remove minimum characters to make two strings anagramsCoding
  • Detect loop in a linked listCoding
  • Sort a linked list of 0s, 1s and 2sCoding
โ† TomTom questions
  1. Interview questions
  2. TomTom
  3. Correct Corrupted Gender Data in Employee Table
Coding

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

  • Array Index Traversal and Perfect Squares Count
  • Optimize Array Traversal and Distinct Pair Difference
  • Remove minimum characters to make two strings anagrams
โ† Write JSON for Empty Object and Employee ObjectLargest Sum Contiguous Subarray โ†’

Collected from public candidate posts and coding forums. Updated Nov 2026.