SQL每日一题(20201124)当Num中的数据同时大于上下两行数据，返回是

SQL每日一题(20210819)
SQL每日一题(20210510)
SQL每日一题(20210908)
SQL每日一题(20211130)
SQL每日一题(20220317)
SQL每日一题(20220708)

select id,
       num,
       case
           when num >
                lag_num and num >
                            lead_num then '是'
           when num <
                lag_num or num <
                           lead_num then '否' end result
from (select id, num, lag(num) over (order by id) lag_num, lead(num) over (order by id) lead_num from t1124) a 

SELECT ID,
       num,
       CASE
           WHEN num >
                numb AND num >
                         numa THEN '是'
           WHEN num <
                numb OR num <
                        numa THEN '否'
           ELSE '其他' END AS result
FROM (SELECT a.id, a.num, b.num AS numb, c.num AS numa
      FROM (SELECT *, row_number() over (ORDER BY id) AS rn FROM t1124) a
               LEFT JOIN (SELECT num, row_number() over (ORDER BY id) + 1 AS rn1 FROM t1124) b ON a.rn = b.rn1
               LEFT JOIN (SELECT *, row_number() over (ORDER BY id) - 1 rn0 FROM t1124) c ON a.rn = c.rn0) t

select cc.id,cc.num1,(case when cc.num1 > cc.num2 and cc.num1 > cc.num3 then '是' else '否'  end) as result
from(select x1.id as id ,x1.num as num1,x2.num as num2,x3.num as num3
from T1124 x1
left join  T1124 x2 on x1.id = x2.id-1
left join  T1124 x3 on x1.id = x3.id+1)cc