197. Rising Temperature
来源:互联网 发布:中文域名怎么买 编辑:程序博客网 时间:2024/06/06 04:51
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.
MySQL:
# Write your MySQL query statement belowselect a.Idfrom Weather a, Weather bwhere datediff(a.Date, b.Date) = 1 and a.Temperature > b.Temperature;
0 0
- 197. Rising Temperature
- 197. Rising Temperature
- LeetCode 197. Rising Temperature
- leetcode.197. Rising Temperature
- leetcode 197. Rising Temperature
- leetcode 197. Rising Temperature
- 197. Rising Temperature
- Leetcode 197. Rising Temperature
- 197. Rising Temperature#1
- 197. Rising Temperature
- 197. Rising Temperature--DATEDIFF()
- 197. Rising Temperature
- 197. Rising Temperature
- 197. Rising Temperature
- leetcode 197. Rising Temperature to_days()
- 【leetcode Database】197. Rising Temperature
- 197. Rising Temperature(Lettcode)
- Rising Temperature
- poj1088 滑雪
- 删除链表中的元素
- 笔记 4.15
- hadoop详细环境配置,单机集群配置(图文并茂)
- 数据结构基础(二):算法
- 197. Rising Temperature
- 坚持
- 笔记 4.16
- 二叉树的最大节点
- 电路中电容、电感的主要作用
- 手机问题点整理和总结
- 单例模式之使用enum枚举数据类型实现
- HDU 5269 ZYB loves Xor I(位运算)
- 中缀表达式转后缀表达式(逆波兰表达式)