몸과 마음이 건전한 SW 개발자

[HackerRank-MSSQL] 해커랭크 Aggregation Weather Observation Station 14 본문

SQL/MSSQL

[HackerRank-MSSQL] 해커랭크 Aggregation Weather Observation Station 14

스위태니 2026. 4. 21. 11:58
728x90

문제 링크

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

정답 코드

select top(1) cast(lat_n as decimal(10, 4)) from station
where lat_n < 137.2345
order by lat_n desc;

728x90
저작자표시 (새창열림)

'SQL > MSSQL' 카테고리의 다른 글

[HackerRank-MSSQL] 해커랭크 Basic Join - The Report  (1) 2026.04.21
[HackerRank-MSSQL] 해커랭크 Basic Join - Average Population of Each Continent  (0) 2026.04.21
[HackerRank-MSSQL] 해커랭크 Aggregation Weather Observation Station 13  (0) 2026.04.21
[HackerRank-MSSQL] 해커랭크 Aggregation Weather Observation Station 2 (Cast, Decimal, Format, Round, N, F)  (1) 2026.04.21
[MSSQL] Microsoft SQL Server, SQL Server Management Studio 빠르게 설치하기 (2026년 4월 20일 최신)  (0) 2026.04.20
'SQL/MSSQL' Related Articles more