Answers for "select single record with same ids"

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

Code answers related to "select single record with same ids"