LEETCODE SQL Q 182.DUPLICATE EMAILS #leetcodesql #sql #interviews

In this video , question 182. which focuses on finding the duplicate emails from the person table. i explain necessary SQL components, including GROUP BY , HAVING and COUNT . please make sure to follow along and try writing the code yourself.

GROUP BY - Used to group rows from a table based on the values of one or more columns.

HAVING - it is also similar to the where but it is used after the group by

COUNT - it is a aggregate function, used to count the number of entries.

Видео LEETCODE SQL Q 182.DUPLICATE EMAILS #leetcodesql #sql #interviews канала Harsh Choudhary