Simply do a GROUP BY, use MAX() to return T if available, else F.
select col_1, max(col_2), max(col_3), max(col_4)
from tablename
group by col_1
Simply do a GROUP BY, use MAX() to return T if available, else F.
select col_1, max(col_2), max(col_3), max(col_4)
from tablename
group by col_1