LeetCode Rising Temperature
来源:互联网 发布:淘宝助理修改宝贝描述 编辑:程序博客网 时间:2024/05/16 17:48
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 b.id as Id from Weather a, Weather b where to_days(a.date) = to_days(b.date) - 1 and a.temperature < b.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
- 海龟交易系统R代码
- 【C语言】求一个数的二进制位模式从左到右翻转后对应的十进制值。
- tabbarviewcontroller标签栏视图控制器
- 学习笔记:OC面向对象(2)
- 第六届蓝桥杯c++B组江西赛区
- LeetCode Rising Temperature
- 向量处理机
- 华为2014机试题-等式变换
- 剑指offer-算法整理
- Certification、Provisioning、Keychain、APP IDs概述
- 第五周项目体验常成员函数
- 表面着色器案例分析
- A*算法
- 二叉搜索