One column in a join needs to be unique
Something like this would work (in Oracle). 

select c.* from (select b.*, row_number() over(partition by b.bic order by b.rnum) rnk from (select rownum rnum, a.* from test a) b) c where rnk = 1;