Answers for "SQL select rows with same values in two column"

1

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
1

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
0

sql select rows with different values in one column

SELECT *
FROM YourTable
WHERE ARIDNR IN (
    SELECT ARIDNR
    FROM YourTable
    GROUP BY ARIDNR
    HAVING COUNT(*) > 1
)
Posted by: Guest on June-17-2020
0

select all same column value in sql

SELECT RollId, count(*) AS c FROM `tblstudents` GROUP BY RollId HAVING c > 1 ORDER BY c DESC
Posted by: Guest on December-16-2020

Code answers related to "SQL select rows with same values in two column"

Browse Popular Code Answers by Language