本文最后更新于 136 天前。
要找出比昨天温度高的天的id，与要找出比经理工资高的员工思路相同
SELECT id
FROM Weather w1
WHERE temperature > (
SELECT temperature
FROM Weather w2
WHERE w1.recordDate = w2.recordDate + 1
)
暂无评论
要找出比昨天温度高的天的id，与要找出比经理工资高的员工思路相同
SELECT id
FROM Weather w1
WHERE temperature > (
SELECT temperature
FROM Weather w2
WHERE w1.recordDate = w2.recordDate + 1
)
