https://www.hackerrank.com/challenges/weather-observation-station-14/problem?isFullScreen=true

 

Weather Observation Station 14 | HackerRank

Query the greatest value of the Northern Latitudes from STATION that are under 137.2345 and truncated to 4 decimal places.

www.hackerrank.com

코드설명

ROUND + MAX 를 활용합니다.

ORACLE 코드

SELECT ROUND(MAX(LAT_N), 4)
FROM STATION 
WHERE LAT_N < 137.2345;

+ Recent posts