sql get all rows with column different values code example

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

Example 2: sql find all different values in column

SELECT DISTINCT
    column_name
FROM
    table_name;