select a.*  ,
        case when row_number() over (partition by a.id order by a.id ) = 1 then b.col4
             else 0
         end col4 from tab1 a left outer join tab2 b on a.id = b.id
 order  by a.id,a.col1