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
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