title: Oracle to SQL Server: Convert keep (dense_rank first ORDER BY ...) over (partition by)
body: <p>Looking to run the following Oracle syntax in SQL server. I know T-SQL not support 'keep' but not sure what to replace it with.</p>
  <pre><code>MIN( ap_year ) KEEP ( DENSE_RANK FIRST ORDER BY ap_year) OVER 
                      ( PARTITION BY no ) AS first_ap_year
  </code></pre>