按活动\u f so 6有条件地排序行

WITH CTE AS 

(select 
ID, 
myuser_insert_time as insert_time,
row_number() OVER (PARTITION BY ID ORDER BY case ACTIVE_F when 6 then 1 else 0 end,  eendmyuser_insert_time desc) as rn
from tbl1)

SELECT * FROM CTE 
WHERE rn = 1

你好像只是想过滤掉 active_f = 6 ，如果我理解正确的话。在计算最大插入时间之前，应该这样做；也就是说，在cte中：

with cte as (
      select ID, myuser_insert_time as insert_time,
             max(myuser_insert_time) over (partition by ID) as max_myuser_insert_time
      from tbl1
      where active_f <> 6
    )
select * 
from CTE 
where myuser_insert_time = insert_time;

你的 max() 也有一个 order by 列，所以你是采取累计 max() . 这是没有必要的。这个 order by 是不必要的（即使代码有效）。
编辑：
如果您需要“6”，如果它是唯一一行，那么使用 row_number() 最后一行：

with cte as (
      select ID, myuser_insert_time as insert_time,
             row_number() over (partition by id
                                order by (case when active_f = 6 then 2 else 1 end),
                                         myuser_insert_time desc
                               ) as rn
      from tbl1
    )
select * 
from CTE 
where rn = 1;

添加 case when active_f =6 then 1 else 0 end 到 order by 解析函数的子句。活动的记录\u f=6人优先。同时使用行号和顺序，按myuser插入时间描述：

WITH CTE AS 

(select 
ID, 
myuser_insert_time as insert_time,
row_number() OVER (PARTITION BY ID ORDER BY myuser_insert_time desc, case when active_f =6 then 1 else 0 end) as rn
from tbl1)

SELECT * FROM CTE 

WHERE rn =  1