LeetCode 627: Swap Salary [SQL]

Solution and walkthrough of leetcode database problem 627: Swap Salary. I'm using MySQL but this solution should work in any SQL dialect such as PostgreSQL SQL Server, etc.
Link to the problem: leetcode.com/p...

[@elainehe8055]

the explanations are so clear!

[@sandeepkv9224]

Nice Explanation...

[@mickyman753]

a interesting answer can be using xor # UPDATE salary # set sex=char(ASCII('m')^ASCII('f')^ASCII(sex)); although we might not remember ascii function function or char typecasting but can explain our approach to interviewer

[@mohit4812]

very good

[@importantegg2706]

I am sorry to say this .. I think your audio is little low.. By the way, Your explanation is good bro..