title: Comparison Group by VS Over Partition By
body: <p>Assuming one table <code>CAR</code> with two columns <code>CAR_ID (int)</code> and <code>VERSION (int)</code>.</p>
  
  <p>I want to retrieve the maximum version of each car.</p>
  
  <p>So there are two solutions (at least) :</p>
  
  <pre><code>select car_id, max(version) as max_version 
    from car  
   group by car_id;
  </code></pre>
  
  <p>Or : </p>
  
  <pre><code>select car_id, max_version 
    from  ( select car_id, version
                 , max(version) over (partition by car_id) as max_version
              from car
                  ) max_ver  
   where max_ver.version = max_ver.max_version
  </code></pre>
  
  <p>Are these two queries similarly performant?</p>