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等,其他字段排序,随机滤重
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等,其他字段排序,随机滤重