title: how to make ranking of value in oracle
body: <p>I have table : tb_user. </p>
  
  <pre><code>id|name|value
  10|boy|500
  20|Ony|200
  10|boy|500
  </code></pre>
  
  <p>When I execute the following query:</p>
  
  <pre><code>Select id,name,sum(value) as grant_total from tb_user group by id,name
  </code></pre>
  
  <p>the result is:</p>
  
  <pre><code>id|name|grant_total
  10|boy |1000
  20|Ony |200
  </code></pre>
  
  <p>I want to add 1 column --> ranking</p>
  
  <pre><code>id|name|grant_total|ranking
  10|boy |1000       |1
  20|Ony |200        |2
  </code></pre>
  
  <p>how to make ranking?</p>