MySQL interview – Advanced Queries

MySQL Advanced Queries

Get unique email count

SELECT COUNT(DISTINCT email) as uniqueEmailCount 
FROM members;

Get duplicate email count

SELECT COUNT(duplicatedEmails.idCount) as numberOfDuplicatedEmails
     SELECT COUNT(id) as idCount
     FROM users
     GROUP BY email
     HAVING idCount > 1) as duplicatedEmails;


Get duplicate emails

SELECT email, COUNT(email) as emailCount
FROM members
GROUP BY email
HAVING emailCount > 1;


How to update a table from another table?


Subscribe To Our Newsletter
You will receive our latest post and tutorial.
Thank you for subscribing!


Leave a Reply

Your email address will not be published.