Answers for "select rows with same id but different value in another column in sql"

select rows with same value in a column

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

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
)