197. Rising Temperature
问题描述
解决方案
-- select A.Id from Weather A ,Weather B where TO_DAYS(B.date)-TO_DAYS(A.Date) =1 and B.Temperature>A.Temperature
-- select B.Id from Weather A ,Weather B where datediff(B.date,A.Date) =1 and B.Temperature>A.Temperature
-- select B.Id from Weather A ,Weather B where subdate(B.date,interval 1 day) =A.Date and B.Temperature>A.Temperature
作者:弦断
出处:http://www.cnblogs.com/ucas/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。