How to select non "unique" rows
SELECT id, idA, COUNT(infos) AS cnt
FROM mytable
GROUP BY infos
HAVING cnt > 1
Try this:
SELECT T1.idA, T1.infos
FROM XXX T1
JOIN
(
SELECT idA
FROM XXX
GROUP BY idA
HAVING COUNT(*) >= 2
) T2
ON T1.idA = T2.idA
The result for the data you posted:
idaA infos 201 1899 201 1959
Something like this should work:
SELECT idA, COUNT(*) FROM XXX GROUP BY idA HAVING COUNT(*) > 1