Zilo SDE-2 Backend Interview(2025)

R1
largest substring with-out repeating charectors

R2

Person
`
Gender
OG1
M
F
M
F
M
M

F
M
F
M
F
F

// Q -> 4

-> with, value , case
Select id from person p where p.gender =‘M’ —> set1
Select id from person p where p.gender =‘F’. -> set2`

Update person p set p.gender = ‘F’ where p.id in (set1)
Update person p set p.gender = ‘M’ where p.id in (set2)

how to do it in single go ?

UPDATE person
SET gender = CASE
WHEN gender = 'M' THEN 'F'
WHEN gender = 'F' THEN 'M'
ELSE gender -- optional: keep others unchanged
END;