如果我没弄错的话你可以用 case 表达式添加另一列，如下所示

select
  ID,
  Type,
  case 
    when Type = 'Credit Card' then yourValue
  end as yourColumnName
from yourTable

如果我理解正确，它将使用窗口函数：

select t.*,
       max(case when type = 'Credit Card' then 1 else 0 end) over (partition by id) as has_credit_card
from t;