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

Previous Video: LeetCode 181 Employees Earning More Than Managers

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 finding duplicate emails and also includes points to keep in mind to develop SQL queries. You will also learn about SELF JOIN.

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

[in_ashish]

Absolutely ! the best playlist i haver ever came across for SQL! No doubt how sir explains the topics in so luicd manner.

[aaravkumarsingh]

select email as Email from person group by email having count(email) >1;

[energizer]

Sir
Very informative and detailed oriented.
This really help us to understand the concepts.
Pl going with similar initiatives....
May God bless you,

[knightganesh]

Great informative content please keep going 👍

[parthpanchal]

count(email) vs count(id) i didnt understand how count(id) works

[sammanluitel]

Why you did count (I'd) I didn't get it. Can you please elaborate?can't it be written count (email) only.Also please say the difference between count(1), count(*), count(particular column)? What's the significance of each of these. Also please include more depth in videos explaining each line and it's significance which helps begineers.

[RitzFootball]

if I don't give DISTINCT id and just use COUNT(id)>1, it'll still work right?

[madhuryadav]

select email
from person
group by email
having count(distinct email)>1

will this work ??

[rohithkotar]

SELECT email from Person
group by email
having count(email) > 1;

[gagansingh]

If I'd column is not primary if we didn't use distinct count it will also shows many times it will be repeated