LeetCode Interview SQL Question with Detailed Explanation | Practice SQL | LeetCode 627

Previous Video: LeetCode 620 Not Boring Movies

In this video I solve and explain a leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question is about swapping the male salary with female and vice versa and also includes points to keep in mind to develop SQL queries. You will also learn about SQL UPDATE and CASE WHEN THEN clauses.

LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.

If you found this helpful, Like and Subscribe to the channel for more content.

#LeetCodeSQL #FAANG #SQLinterviewQuestions

[rajatsharma]

you explain questions and solutions really well....keep doing what you are doing...all the best!

[jugabrat]

Very helpful video, thanks for that, keep doing

[TheEleetcoder]

learnt a new concept of CASE WHEN statements!

[satishpaul]

when I searched for SQL leedcode question solution then I find your videos

[abhisheksharma]

update salary
set sex=case when sex='m' then 'f'
when sex='f' then 'm'
end
where id in (select id from salary); -- this where clause is used to help with Query optimization

[mickyman]

update salary set sex=if(sex='m', 'f', 'm');

[LordSarcasticVlogger]

UPDATE Salary
SET sex = IF(sex = 'm', 'f', 'm');