【leetcode Database】197. Rising Temperature
来源:互联网 发布:java布局方式 编辑:程序博客网 时间:2024/05/18 02: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 |+----+解析:
本题可以用自连接来做,用表的别名来解决即可。代码如下:
# Write your MySQL query statement belowSELECT a.Id FROM Weather a,Weather b WHERE a.Temperature > b.Temperature AND a.Date = ADDDATE(b.Date,1);
0 0
- 【leetcode Database】197. Rising Temperature
- [LeetCode][Database]Rising Temperature
- 【leetcode】 database Rising Temperature
- Leetcode:Rising Temperature database
- 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 Rising Temperature
- Leetcode: Rising Temperature
- 【LeetCode】Rising Temperature
- 【Leetcode】Rising Temperature
- leetcode-Rising Temperature
- 【LeetCode】197、Rising Temperature
- 197. Rising Temperature
- 197. Rising Temperature
- 完美安装 Anaconda3 + PyQt5 + Eric6
- Eclipes项目怎么转成android studio版
- Java的MyBatis框架中Mapper映射配置的使用及原理解析
- Spring-13:泛型依赖注入(Spring4.X新特性)
- Error:Execution failed for task...finished with non-zero exit value 2
- 【leetcode Database】197. Rising Temperature
- error MSB6006: “cmd.exe”已退出,代码为 3。
- poj2049 Finding Nemo
- stagefright中的编解码缓存区进行分析
- poj1201 intervals
- Git+GitHub,构建自己的开源仓库之Git分支
- web.xml文件详解
- HDU 5754 Life Winner Bo(博弈)
- 源码-PL/SQL从入门到精通-第十八章-PL/SQL性能优化建议-Part 1