display only once in column if the value are the same but different in other columns php mysql site:stackoverflow.com code example

Example: 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
)