Answers for "select one from same values in two column"

select rows with same value in a column

select * from table where email in (
    select email from table
    group by email having count(*) > 1
)

Posted by: Guest on June-10-2021

select rows with same value in a column

SELECT email,
       count(*) AS c
FROM TABLE
GROUP BY email
HAVING c > 1
ORDER BY c DESC

Posted by: Guest on June-10-2021

Code answers related to "select one from same values in two column"