LeetCode 197. Rising Temperature
来源:互联网 发布:淘宝上找不到一淘网 编辑:程序博客网 时间:2024/05/18 01:54
题目描述:
197. Rising Temperature My Submissions QuestionEditorial Solution
Total Accepted: 16455 Total Submissions: 62463 Difficulty: Easy
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 |
+—-+
Subscribe to see which companies asked this question
select w1.Id from Weather w1, Weather w2 where (To_DAYS(w1.Date) = To_DAYS(w2.Date) + 1) AND w1.Temperature > w2.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 to_days()
- 【leetcode Database】197. Rising Temperature
- [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
- 197. Rising Temperature
- 197. Rising Temperature
- (OK) Android 5+ —— error: only position independent executables (PIE) are supported.
- Skia深入分析8——Skia的GPU绘图
- 主流移动端参数参考
- Context的学习
- 基础部分(The Basics)
- LeetCode 197. Rising Temperature
- qdqwdqwd
- $.ajax()方法详解
- Tomcat配置虚拟目录及虚拟主机
- 【思想感悟】追究责任OR解决问题???
- Android WebView使用精解(一)
- HTML5之canvas基础
- 俗语说、俗话说
- 设计模式二之策略模式