Check if column has same value in any row
Something like this, may be
select 
 article_id, user_id, 
 case 
   when count(1) over (partition by article_id) &gt; 1 then 'true' 
   else 'false' 
 end is_connected
from something