title: Sort by each columns in oracle
body: <p>I have a table </p>
  
  <pre><code>DPN      Incidents  wk32        wk31             wk30            wk29
  15326868    2.00    16,020.98   9,586.14        
  13655518    2.00    15,246.40   2,619.89        
  13592065    4.00    4,138.67    7,851.41    7,725.56          7,593.11
  13968309    4.00    3,027.89    3,788.18    10,155.71         2,328.68
  13533086    4.00    10,266.52   6,479.47    8,761.08         10,949.50
  13838079    3.00    5,890.04    1,214.42                     10,445.45
  </code></pre>
  
  <p>If they enter a topx=2</p>
  
  <p>I should have the output as</p>
  
  <pre><code>DPN # of Incidents  wk32               wk31     wk30             wk29
  15326868    2.00    16,020.98       9,586.14        
  13655518    1.00    15,246.40           
  13592065    1.00                    7,851.41                 
  13968309    1.00                              10,155.71        
  13533086    2.00                              8,761.08       10,949.50      
  13838079    1.00                                             10,445.45 
  </code></pre>
  
  <p>The above output is it should sort each week by desc and display in the same format as above and Also recalculate no of incidents.
  Incidents is how many columns the value is present for each.
  Pls let me know how to do that.</p>