select a.id,a.career, a.term, a.bill_career from rg_semester a, /* this rg_semester table is assumption */ rg_semester b where a.id = b.id and a.bill_career != b.bill_career and a.id in (select a.id from rg_semester group by a.id having count(a.id)>1); ID CAREER TERM BILL_CAREE -- ---------- ----- ---------- B GR 50 GR B UGR 50 UGR C GR 50 GR C UGR 50 UGR great!