Finding duplicates values and print them only once from a TEST table with two different queries . only use IN and EXIST nested and non nested. NO GROUPBY & NO PARTITION, LIMIT , row_id. Basic SQL

should only print B and D. Two queries only nested and non nested (IN and EXIST) . NO GROUPBY to find duplicates

TESTID TESTName TESTPrice 1 2 3 4 5 6 7 NULL B A D D B B NULL 100 100 100 100 100 100 100 NULL