return rows that have the same column values sql 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: select all same column value in sql

SELECT RollId, count(*) AS c FROM `tblstudents` GROUP BY RollId HAVING c > 1 ORDER BY c DESC

Tags:

Sql Example

Related