title: How to partition based on two columns in Oracle/sql
body: <p>Please help me with the following</p>
  
  <p>Question:</p>
  
  <pre>
  +------+----------+
  | Name | Sub-name |
  +------+----------+
  | A    | x        |
  | A    | x        |
  | B    | x        |
  | A    | y        |
  | B    | y        |
  +------+----------+
  </pre>
  
  <p>Desired Result:</p>
  
  <pre>
  +------+----------+-------+
  | Name | Sub-name | Count |
  +------+----------+-------+
  | A    | x        |     2 |
  | A    | x        |     2 |
  | B    | x        |     1 |
  | A    | y        |     1 |
  | B    | y        |     1 |
  +------+----------+-------+
  </pre>
  
  <p>Three columns Name, Subname, Count</p>
  
  <p>I want to partition based on both name and subname.</p>