title: Case sensitive duplicate values in oracle
body: <p>I have a table with the below sample records</p>
  
  <pre><code>Name    Profession      University
  -----   --------------  ---------------
  Ram     Student         xxxUniversity
  Ravi    Professor       xyzUniversity
  Reshma  Professor       abcUniversity
  Ram     StudenT         xxxUniversity
  </code></pre>
  
  <p>As seen above "Ram" has case sensitive duplicate records. My Oracle query should return distinct records and one record for "Ram", which has the maximum number of uppercase character in Profession column. </p>
  
  <p>Expected result</p>
  
  <pre><code>    Name    Profession      University
      -----   --------------  ---------------
      Ravi    Professor       xyzUniversity
      Reshma  Professor       abcUniversity
      Ram     StudenT         xxxUniversity
  </code></pre>