题目:
思路:
这道题主要是要找出哪一天的气温比昨天高,这就得用上 MySQL 的 DATE_SUB() 函数
语法格式:
DATE_SUB(date, INTERVAL expr type)
date: 参数是合法的日期表达式
expr: 参数是您希望添加的时间间隔
type: MICROSECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR, SECOND_MICROSECOND, MINUTE_MICROSECOND, MINUTE_SECOND, HOUR_MICROSECOND, HOUR_SECOND, HOUR_MINUTE, DAY_MICROSECOND, DAY_SECOND, DAY_MINUTE, DAY_HOUR, YEAR_MONTH.
代码:
SELECT W1.id
FROM Weather W1, Weather W2
WHERE W1.Temperature > W2.Temperature AND (DATE_SUB(W1.recordDate, INTERVAL 1 DAY) = W2.recordDate)
结果如下:
如果觉得还有更好的方法,就请留言吧~~
觉得不错,就点赞或者关注
谢谢~ ~