Let’s say you have a table and you want to know how many rows have the same e-mail adress.
SELECT count(*), email FROM email_list GROUP BY email HAVING count(*)>1 ORDER BY count(*) DESC;
Full-Stack software architect/engineer (currently working in the Big Data space), drummer, motorcyclist, and artist.
Let’s say you have a table and you want to know how many rows have the same e-mail adress.
SELECT count(*), email FROM email_list GROUP BY email HAVING count(*)>1 ORDER BY count(*) DESC;