select id, count(*)
from table_A
group by id
having count(*) > 1;


Is that you want?

Tamil