【Leetcode】Rising Temperature
来源:互联网 发布:公司域名备案流程 编辑:程序博客网 时间:2024/05/17 09:29
题目链接:https://leetcode.com/problems/rising-temperature/
题目:
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 |
+—-+
思路:
二表联查
算法:
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
- [LeetCode][Database]Rising Temperature
- LeetCode Rising Temperature
- Leetcode: Rising Temperature
- 【LeetCode】Rising Temperature
- 【leetcode】 database Rising Temperature
- Leetcode:Rising Temperature database
- 【Leetcode】Rising Temperature
- leetcode-Rising Temperature
- LeetCode 197. Rising Temperature
- leetcode.197. Rising Temperature
- leetcode 197. Rising Temperature
- leetcode 197. Rising Temperature
- Leetcode 197. Rising Temperature
- 【LeetCode】197、Rising Temperature
- [LeetCode]Rising Temperature,解题报告
- leetcode rising Temperature SQL语句
- leetcode 197. Rising Temperature to_days()
- 【leetcode Database】197. Rising Temperature
- IOS使状态栏的颜色变成白色
- I/dalvikvm: Total arena pages for JIT: 是什么意思?
- zookeeper初步
- 使用Jenkins+xcodebuild搭建iOS的持续集成系统
- Map的clear()方法
- 【Leetcode】Rising Temperature
- 转义字符含义整理
- mapreduce生成HFile通过bulkload入hbase库问题
- canvas之二:绘制三角形
- 纯HTML的静态网页中添加一段统计网页访问量的JAVA Script代码
- UI基础_hitTest扩大响应范围
- css3-飞进页面效果
- find5 刷安卓4.4 魔趣
- Container With Most Water