1.将相同日期内的相同名字的多条记录只保存一条记录
select t.*,
row_number() over(partition by t.time_stamp, t.ne_name order by t.time_stamp) rn
from user t
1.将相同日期内的相同名字的多条记录只保存一条记录
select t.*,
row_number() over(partition by t.time_stamp, t.ne_name order by t.time_stamp) rn
from user t