title: What's the point of the ALL modifier in window functions?
body: <p>I read the definition of the all modifier <a href="https://www.sqlshack.com/use-window-functions-sql-server/" rel="nofollow noreferrer">ALL</a> as </p>
  
  <blockquote>
    <p>ALL is an optional keyword. When you will include ALL it will count
    all values including duplicate ones. DISTINCT is not supported in
    window functions</p>
  </blockquote>
  
  <p>My understanding is that it automatically would count all values anyway. </p>
  
  <p>If that's the case, then why create an ALL keyword at all?</p>