Eliminate results if they are equal within a group
My query returns results like this: Id E_ID FCTR 1 123 ABC123 1 345 ABC123 2 234 ABC123 2 456 ABC121
I want to eliminate the first 2 columns having Id =1 because within the group the value of FCTR is same. Bascially I need to ocmpare FCTR to itself fora particular ID. I tried using row_number over partition by etc. but does not work.