• Lc197-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) | RecordDate(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 |
    +----+
    
    来源:力扣(LeetCode)
    链接:https://leetcode-cn.com/problems/rising-temperature
    著作权归领扣网络所有。商业转载请联系官方授权,非商业转载请注明出处。
    # Write your MySQL query statement below
    --笛卡儿积 加上时间做差函数
    select a.id from weather a,weather b
    where datediff(a.recorddate,b.recorddate) = 1
    and a.temperature > b.temperature
  • 相关阅读:
    C#面向对象
    C#语句
    C#语言数据类型
    Jupyter Notebook(iPython)
    BeautifulSoup模块
    requests模块
    爬虫基本原理
    版本控制系统
    支付宝支付
    django内置组件——ContentTypes
  • 原文地址:https://www.cnblogs.com/xiaoshahai/p/12185611.html
Copyright © 2020-2023  润新知