题意:查询比昨天温度高的日期的id
思路:学习了to_days()函数
学习链接:http://www.45it.com/database/201210/32985.htm
select w1.Id
from Weather as w1, Weather as w2
where to_days(w1.Date) = to_days(w2.Date) + 1 and w1.Temperature > w2.Temperature;
题意:查询比昨天温度高的日期的id
思路:学习了to_days()函数
学习链接:http://www.45it.com/database/201210/32985.htm
select w1.Id
from Weather as w1, Weather as w2
where to_days(w1.Date) = to_days(w2.Date) + 1 and w1.Temperature > w2.Temperature;