mun dev

[HackerRank] Weather Observation Station 17 오라클 풀이 본문

알고리즘/HackerRank

[HackerRank] Weather Observation Station 17 오라클 풀이

mndev 2024. 2. 2. 13:40

문제링크

 

Weather Observation Station 17 | HackerRank

Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places.

www.hackerrank.com

 

 

코드

select round(long_w,4)
from station
where lat_n = (select min(lat_n)
              from station
              where lat_n > 38.7780);

'알고리즘 > HackerRank' 카테고리의 다른 글

[HackerRank] Population Census 오라클 풀이  (0) 2024.02.02
[HackerRank] Revising the Select Query II 오라클 풀이  (0) 2024.02.02
[HackerRank] SQL Project Planning 오라클 풀이  (0) 2024.02.02
[HackerRank] Contest Leaderboard 오라클 풀이  (1) 2024.02.02
[HackerRank] Top Competitors 오라클 풀이  (1) 2024.01.31
'알고리즘/HackerRank' Related Articles more