title: duplicate maximum values from sql server
body: <pre><code>date    maxval
  19/08/2015  1
  19/08/2015  2
  19/08/2015  2
  19/08/2015  1
  20/08/2015  6
  20/08/2015  7
  20/08/2015  8
  20/08/2015  9
  </code></pre>
  
  <p>Desired output
                 date    maxval
             19/08/2015   2
             19/08/2015   2
             20/08/2015   9</p>
  
  <p>required duplicate maximum values like if 19/08/2015 in 6 is an max values but i have duplicate so required both max and 20/08/2015 have only one max value so it displaying one max val please how we can get from sql server query.</p>
  
  <p>"</p>