语法格式:row_number() over(partition by 分组列 order by 排序列 desc)
SELECT * FROM (
SELECT ROW_NUMBER()OVER(PARTITION BY XMID ORDER BY ACTIVITYSTATUS)RN, PROJECT_NEW.* FROM PROJECT_NEW) T WHERE T.RN=1
语法格式:row_number() over(partition by 分组列 order by 排序列 desc)
SELECT * FROM (
SELECT ROW_NUMBER()OVER(PARTITION BY XMID ORDER BY ACTIVITYSTATUS)RN, PROJECT_NEW.* FROM PROJECT_NEW) T WHERE T.RN=1