Leetcode197. Rising Temperature
来源:互联网 发布:0.32双丝并绕数据 编辑:程序博客网 时间:2024/06/08 00:46
Given a Weather table, write a SQL query to find all dates’ Ids with higher temperature compared to its previous (yesterday’s) dates.
+———+————+——————+
| Id(INT) | Date(DATE) | Temperature(INT) |
+———+————+——————+
| 1 | 2015-01-01 | 10 |
| 2 | 2015-01-02 | 25 |
| 3 | 2015-01-03 | 20 |
| 4 | 2015-01-04 | 30 |
+———+————+——————+
For example, return the following Ids for the above Weather table:
+—-+
| Id |
+—-+
| 2 |
| 4 |
+—-+
使用了TO_DAYS()函数转换日期
select w1.Id from Weather w1 inner join Weather w2 on TO_DAYS(w1.Date)=TO_DAYS(w2.Date)+1 and w1.Temperature>w2.Temperature;
阅读全文
0 0
- leetcode197-Rising Temperature
- Leetcode197. Rising Temperature
- Rising Temperature
- Rising Temperature
- Rising Temperature
- Rising Temperature
- Rising Temperature
- Rising Temperature
- [LeetCode][Database]Rising Temperature
- LeetCode Rising Temperature
- Leetcode: Rising Temperature
- 【LeetCode】Rising Temperature
- 【leetcode】 database Rising Temperature
- Rising Temperature Inner Join
- Rising Temperature--easy
- Leetcode:Rising Temperature database
- 【Leetcode】Rising Temperature
- leetcode-Rising Temperature
- Fastjson toJSONString用单引号进行转换
- Leetcode596. Classes More Than 5 Students
- angularjs input 表单校验指令整理
- 使用@ResponseBody的中文乱码问题
- Dom 倒计时按钮
- Leetcode197. Rising Temperature
- webpack安装与基本配置
- NKOJ-1887 借教室 【NOIP2012 day2】
- WeiXinUtil
- .NET中的反射(2)
- display、position填坑
- Dom 密码强度检查
- 动态获取下拉框的值与ajax中对方法的隐藏与显示
- 定义asyncExportFile服务,通过异步下载导出文件