Reply to thread

Message: <blockquote data-quote="hrm" data-source="post: 10448789" data-attributes="member: 88125">machan me approach try karapan.habay math meke output gaththe ne. gedara DB ekak install karala ne.result set eka adjust karaganin group by clause eka one widiyata change karagene.meka ubata nikam idea ekak ganna witharai danne mata test karaganne widiyak nethi nisa.Oracle wala nam sysntax tikak wenas wenewa. ehema unoth DECODE function eka use karapan.SELECT  t1.id, t1.name, t1.team,           t2.month, MAX(t2.year) ,           'OT' = case t2.type               when 'OT' then t2.type,           'Incent'= case t2.type               when 'Incent' then t2.typeFROM    Table1 t1 INNER JOIN Table2 t2ON       t1.id = t2.idGROUP BY t1.id, t1.name,t1.team, t2.month</blockquote>

Top Bottom