MS SQL/MS SQL : HackerRankMS SQL- Weather Observation Station 2(sum, round)

MS SQL/MS SQL : HackerRank

코딩왕ll 2022. 4. 26. 09:47

728x90

Weather Observation Station 2 | HackerRank

Write a query to print the sum of LAT_N and the sum of LONG_W separated by space, rounded to 2 decimal places.

www.hackerrank.com

[problem]

[analysis]

1. SUM 이용

2. ROUND(컬럼명/값,n) 값을 소수점이하 n자리수로 반올림

[solution]

728x90