代码:
inner join 至少存在一个 返回行
datediff 日期差
# Write your MySQL query statement below
SELECT b.id
FROM Weather a INNER JOIN Weather b
WHERE DATEDIFF(b.recordDate,a.recordDate)=1
AND b.Temperature>a.Temperature
代码:
inner join 至少存在一个 返回行
datediff 日期差
# Write your MySQL query statement below
SELECT b.id
FROM Weather a INNER JOIN Weather b
WHERE DATEDIFF(b.recordDate,a.recordDate)=1
AND b.Temperature>a.Temperature