title: Oracle scenario
body: <p>Please help me in solving below scenario :
  I/p</p>
  
  <pre><code>Name salary
  Ram 200
  Shyam 900
  Rabi 700
  Ram 600
  Rabi 100
  Shyam 300
  </code></pre>
  
  <p>O/p</p>
  
  <pre><code>Name. Salary
  Ram 200
  Ram 800
  Shyam 900
  Shyam 1200
  Rabi 700
  Rabi 800
  </code></pre>
  
  <p>How to do this using oracle sql query ?</p>