TO_DAYS(date) 给定一个日期date, 返回一个天数 (从年份0开始的天数 )。
题目连接:to_days()函数的考察
答案:
select w1.Id as ID
from Weather w1,Weather w2
where TO_DAYS(w1.ReDate) - TO_DAYS(w2.ReDate) = 1 and w1.Temp>w2.Temp
TO_DAYS(date) 给定一个日期date, 返回一个天数 (从年份0开始的天数 )。
题目连接:to_days()函数的考察
答案:
select w1.Id as ID
from Weather w1,Weather w2
where TO_DAYS(w1.ReDate) - TO_DAYS(w2.ReDate) = 1 and w1.Temp>w2.Temp