Posted by: Aryan February 11, 2005
Login in to Rate this Post:
0
?
Hurray, Here is the answer.
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
Good Luck.