목록TRUNCATE (1)

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

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

문제 링크https://www.hackerrank.com/challenges/weather-observation-station-13/problem?isFullScreen=true Weather Observation Station 13 | HackerRankQuery the sum of Northern Latitudes having values greater than 38.7880 and less than 137.2345, truncated to 4 decimal places.www.hackerrank.com정답 코드SELECT CAST(SUM(LAT_N) AS DECIMAL(10, 4))FROM STATION WHERE LAT_N > 38.7880 AND LAT_N 느낀점MS SQL Server에는 TR..
SQL/MSSQL 2026. 4. 21. 11:54
이전 Prev 1 Next 다음