oracle SQL - 去除重复 ROW_NUMBER() OVER()

ROW_NUMBER() OVER(PARTITION BY ** ORDER BY * DESC ) RN

1、举例：

select * from (

select tf.*,ROW_NUMBER() OVER(PARTITION BY ** ORDER BY * DESC ) RN from t_zzm_info tf

) from tf where tf.rn = 1

2、运用范围

表数据某一/几字段确定唯一，比如自增段ID等，其他字段排序，随机滤重