title: get Max value without group by 1 row sql query
body: <p>i need help to get a value from a table without grouping one field.</p>
  
  <p>the table design is like this</p>
  
  <pre><code>Progress    DocNum    Project
  ---------------------------
  30        10         1111
  70        11         1111
  30        10         1112
  100       12         1111
  70        13         1112
  </code></pre>
  
  <p>then i want data like this.
  get the max progress for each project, without grouping DocNum</p>
  
  <pre><code>Progress    DocNum    Project
  ---------------------------
  100       12         1111
  70        13         1112
  </code></pre>
  
  <p>how someone can help me.
  thankyou very much before</p>