I have a program in SQL plus that is currently duplicating. I beleive i need to add a distinct. I currently have a distinct at the beginning of my select, but i need to another distinct somewhere in the middle. how do i do multiple distincts. I.E;
select distinct 'ver12345', a.ssn_id, b.ssn_id, (I need a distinct at this point,)a.last_name.