| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| 31 |
Tags
- 그리디
- Spark
- MySQL
- airflow webserver
- 데이터 엔지니어
- delete join
- docker
- Data Engineering
- Airflow
- docker container
- 백준 온라인 저지
- dsf
- docker image
- telegram
- 백준온라인저지
- data_engineer
- 2023년 목표
- 프로그래머스
- datacamp
- Pseudo Lab
- leetcode
- hackerrank
- terraform
- airflow architecture
- SQL
- 빅데이터를 지탱하는 기술
- BOT
- Dynamic Programming
- 알고리즘
- Python
Archives
- Today
- Total
Lim Seunghyun Space
[Leetcode] 197. Rising Temperature 본문
문제 출처
Rising Temperature - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
나의 풀이(MySQL)
SELECT w2.id
FROM Weather AS w1
JOIN Weather As w2
ON DATE(w1.recordDate) = DATE_SUB(w2.recordDate, INTERVAL 1 DAY)
WHERE w1.temperature < w2.temperature728x90
'SQL > SQL 문제' 카테고리의 다른 글
| [LeetCode] Market Analysis I (0) | 2023.03.18 |
|---|---|
| [Leetcode] Exchange Seats (0) | 2023.03.18 |
| [Leetcode] 196. Delete Duplicate Emails (0) | 2022.04.18 |
| [Leetcode] 184. Department Highest Salary (0) | 2022.03.25 |
| [Leetcode] 183. Customers Who Never Order (0) | 2022.03.23 |