title: Kindly help to get office wise data row wise
body: <pre><code>select NUM_OFC_CODE,NUM_RO_CODE, 
   case when TXT_MONTH='JAN' then 1 ELSE 0 end as JAN,
  case when TXT_MONTH='FEB' then 1 ELSE 0  end as FEB,
  case when TXT_MONTH='MAR' then 1  ELSE 0 end as MAR,
  case when TXT_MONTH='APR' then 1 ELSE 0  end as APR,
  case when TXT_MONTH='MAY' then 1 ELSE 0  end as MAY,
  case when TXT_MONTH='JUN' then 1 ELSE 0 end as JUN,
  case when TXT_MONTH='JUL' then 1 ELSE 0 end as JUL,
  case when TXT_MONTH='AUG' then 1 ELSE 0 end as AUG,
  case when TXT_MONTH='SEP' then 1 ELSE 0  end as SEP,
  case when TXT_MONTH='OCT' then 1 ELSE 0  end as OCT,
  case when TXT_MONTH='NOV' then 1 ELSE 0  end as NOV,
  case when TXT_MONTH='DEC' then 1 ELSE 0 end as DEC 
   from LEG_OMBUDSMAN_NONMACT where
   NUM_YEAR=2019   group by NUM_OFC_CODE,TXT_MONTH,NUM_RO_CODE;
  </code></pre>
  
  <p>Result is showing as below:-</p>
  
  <pre><code>NUM_OFC_CODE    NUM_RO_CODE JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
  
  280400          280000      0   0   0   0   0   0   0   1           0   0
  282300          280000      0   0   0   0   0   0   0   1   0       0   0
  281600          280000      0   0   0   0   0   0   0   1   0       0   0
  280500          280000      0   0   0   0   0   0   1   0   0       0   0
  280500          280000      0   0   0   1   0   0   0   0   0       0   0
  281800          280000      0   0   0   0   0   0   0   1   0       0   0
  282200          280000      0   0   0   0   0   0   0   1   0       0   0
  280500          280000      0   0   0   0   1   0   0   0   0       0   0
  280500          280000      0   0   0   0   0   1   0   0   0       0   0
  280500          280000      0   0   0   0   0   0   0   1   0       0   0
  281300          280000      0   0   0   0   0   0   0   1   0       0   0
  </code></pre>
  
  <p>I want office wise data. If August data is present, Then It should show 1 else 0.  Like wise for other months. But in my query Separate row is showing for separate months.</p>