SQL質疑応答スレ 18問目

[0085 NAME IS NULL 2018/02/28(水) 08:09:46.03 ID:???]

>>44
これでもいける
select c1,
case when count(*) = count(c2)
then max(c2)
else 0
end
from t1
group by c1
order by c1