728x90
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
Problem
Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345 . Truncate your answer to 4 decimal places.
-> lat_n이 137.2345 보다 작은 값중에서 제일 큰 값을 소수점 4자리로 출력하시오.
Answer
select truncate(max(lat_n),4)
from station
where lat_n < 137.2345'Language > SQL' 카테고리의 다른 글
| [HackerRank][SQL] Weather Observation Station 16 - 컴도리돌이 (0) | 2022.05.23 |
|---|---|
| [HackerRank][SQL] Weather Observation Station 15 - 컴도리돌이 (0) | 2022.05.22 |
| [HackerRank][SQL] Weather Observation Station 13 - 컴도리돌이 (0) | 2022.05.20 |
| [HackerRank][SQL][JOIN] Basic Join, Challenges - 컴도리돌이 (0) | 2022.05.19 |
| [HackerRank][SQL][JOIN] Basic Join, Population Census - 컴도리돌이 (0) | 2022.05.19 |
