Oracle去重保留一条(本次我们用PARTITION BY分区筛选来解决):
select temp.*
from (select t.*,row_number() OVER(PARTITION BY NAVLATESTDATE ORDER BY t.id asc) as row_flg from new_fund_net_value_data t ) temp
where temp.row_flg = '1'
Oracle去重保留一条(本次我们用PARTITION BY分区筛选来解决):
select temp.*
from (select t.*,row_number() OVER(PARTITION BY NAVLATESTDATE ORDER BY t.id asc) as row_flg from new_fund_net_value_data t ) temp
where temp.row_flg = '1'