查询今天比前一天温度低的Id。
select a.Id from Weather a, Weather b where TO_DAYS(a.Date) = TO_DAYS(b.Date) + 1 and a.Temperature > b.Temperature;
查询今天比前一天温度低的Id。
select a.Id from Weather a, Weather b where TO_DAYS(a.Date) = TO_DAYS(b.Date) + 1 and a.Temperature > b.Temperature;
转载于:https://www.cnblogs.com/willaty/p/8394670.html