oracle - SQL - Case statement for exception -

oracle - SQL - Case statement for exception -

i have database represented (very simplified) following.

name boss type testperson1 testboss1 1 testperson1 testboss2 1 testperson1 testboss3 1 testperson1 testboss1 2

how name , boss when type 2 (even if exists type 1)

i know should utilize case , exists clauses, i'm lost how that.

for values, i'd query return

testperson1 testboss2 1 testperson1 testboss3 1 testperson1 testboss1 2

oracle exception case