title: Select records using max values for two columns
body: <p>I have a table laid out similar to this. I need to select distinct vendor number that has the highest year value and the highest month value</p>
  
  <p>VENDORMONTHLY:</p>
  
  <pre><code>id  Vendor    Year     month    More stuff(More columns)
  ---|---------|-------|-------|---------|
  1  | 93000   | 2017  | 3     | sadf    |
  2  | 93000   | 2017  | 2     | asdf    |
  5  | 93000   | 2017  | 1     | asdf    |
  3  | 93000   | 2016  | 12    | fff     |
  4  | 93000   | 2016  | 11    | ffff    |
  6  | 40000   | 2017  | 2     | fff     |
  7  | 40000   | 2017  | 1     | fff     |
  8  | 40000   | 2016  | 12    | fff     |
  </code></pre>
  
  <p>The result would look like this. I can not for the life of me come up with a query that will give me what I need. </p>
  
  <pre><code>id  Vendor    Year     month    More stuff(More columns)
  ---|---------|-------|-------|---------|
  1  | 93000   | 2017  | 3     | sadf    |
  6  | 40000   | 2017  | 2     | fff     |
  </code></pre>
  
  <p>Any help would be greatly appreciated!</p>