title: How to get the max row count grouped by the ID in sql
body: <p>Say I have this table: 
  (column: <code>Row</code> is a count based on the column <code>ID</code>)</p>
  
  <pre><code>ID  | Row  | State | 
  1   | 1    | CA    |
  1   | 2    | AK    |
  2   | 1    | KY    |
  2   | 2    | GA    |
  2   | 3    | FL    |
  3   | 1    | WY    |
  3   | 2    | HI    |
  3   | 3    | NY    |
  3   | 4    | DC    |
  4   | 1    | RI    |
  </code></pre>
  
  <p>I'd like to generate a new column that would have the highest number in the <code>Row</code> column grouped by the <code>ID</code> column for each row. How would I accomplish this? I've been messing around with MAX(), GROUP BY, and some partitioning but I'm getting different errors each time. It's difficult to finesse  this correctly. Here's my target output:</p>
  
  <pre><code>ID  | Row  | State | MaxRow
  1   | 1    | CA    | 2
  1   | 2    | AK    | 2
  2   | 1    | KY    | 3
  2   | 2    | GA    | 3
  2   | 3    | FL    | 3
  3   | 1    | WY    | 4
  3   | 2    | HI    | 4
  3   | 3    | NY    | 4
  3   | 4    | DC    | 4
  4   | 1    | RI    | 1
  </code></pre>