https://www.hackerrank.com/challenges/weather-observation-station-16/problem

 

Weather Observation Station 16 | HackerRank

Query the smallest of STATION's Northern Latitudes that is greater than 38.7780, and round to 4 decimal places

www.hackerrank.com

코드설명

ROUND + MIN을 활용합니다.

 

ORACLE 코드

SELECT ROUND(MIN(LAT_N), 4)
FROM STATION
WHERE LAT_N > 38.7780;

+ Recent posts