Leetcode 197. 上升的温度(datediff、暴力双表连接)

2021-04-08 13:33:50 浏览数 (1)

代码语言:javascript复制
select w1.id   
    from weather w1
    join weather w2 on
    datediff(w1.recorddate,w2.recorddate)=1
    and w1.temperature>w2.temperature

0 人点赞