Okay,

kinda new at this:


I have Id's that can have duplicates. I also have programs that can have duplicates. I am looking for a list of IDs with programs that have a rowcount > 1 for that given id.


Example

ID Program
--- ----------
111 12345 <----------These are the records I want
111 12345 <----------
222 32145
333 99999
444 55555
444 66666



with my current query I keep getting 1 ID per 1 Program?


What PL/SQL do I need?


Thanks in advance!

J

Not PL/SQL, just SQL:

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