title: how to select only row with max sequence without using a subquery?
body: <p>I'm trying to select only the row with the highest seq for each ID</p>
  
  <pre><code>ID  |  Seq   |  Age
  -------------------
   A      1       20   
   A      2       30
   B      1       25
   B      2       32
   B      3       44
   B      4       48
   C      1       11
  </code></pre>
  
  <p>This appears to work</p>
  
  <pre><code>SELECT ID, Age
  FROM Persons a
  WHERE Seq = (SELECT MAX(Seq) FROM Persons b WHERE a.ID = b.ID)
  </code></pre>
  
  <p>But is this the best way, the only way? I don't like using subqueries if I don't have to and I recall you can use something but I forget what it is. Any idea?</p>