I have a table with data in following order. ID Career Term Bill_Career A GR 50 GR B UGR 50 UGR C UGR 50 UGR D GR 50 GR E UGR 50 UGR A UGR 50 GR B GR 50 GR C GR 50 GR What I am looking for is, any ID that occures twice with Different Bill_Career. How can I make the output look like ID Career Term Bill_Career B UGR 50 UGR B GR 50 GR C UGR 50 UGR C GR 50 GR