Oracle to SQL Server: Convert keep (dense_rank first ORDER BY ...) over (partition by)

Viewed 21

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.

MIN( ap_year ) KEEP ( DENSE_RANK FIRST ORDER BY ap_year) OVER 
                    ( PARTITION BY no ) AS first_ap_year
0 Answers
Related