Check out example codes for "sql select rows with different values in one column". It will help you in understanding the concepts better.

Code Example 1

SELECT *
FROM YourTable
WHERE ARIDNR IN (
    SELECT ARIDNR
    FROM YourTable
    GROUP BY ARIDNR
    HAVING COUNT(*) > 1
)

Learn ReactJs, React Native from akashmittal.com