|
1
2
3
4
5
|
/* Write your PL/SQL query statement below */
select t1.id as id
from Weather t1,Weather t2
where (t1.recordDate-t2.recordDate)=1
and t1.temperature>t2.temperature
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 620. Not Boring Movies (0) | 2022.03.17 |
|---|---|
| leetcode 596. Classes More Than 5 Students (0) | 2022.03.17 |
| leetcode 183. Customers Who Never Order (0) | 2022.03.17 |
| leetcode 182. Duplicate Emails (0) | 2022.03.17 |
| leetcode 181. Employees Earning More Than Their Managers (0) | 2022.03.17 |
댓글