We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 2
Weather Observation Station 2
Sort by
recency
|
1267 Discussions
|
Please Login in order to post a comment
MYSQL
SELECT ROUND(SUM(LAT_N), 2) AS sum_of_lat_n, ROUND(SUM(LONG_W), 2) AS sum_of_long_w FROM STATION;
Select ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2) From Station
No need to cast anything
select (cast(sum(LAT_N) as numeric(20,2))), cast(sum(LONG_W) as numeric(20,2)) from STATION;
MS SQL : SELECT CONCAT(CAST(ROUND(SUM(LAT_N),2) AS DECIMAL(10,2)) ,' ', CAST(ROUND(SUM(LONG_W),2) AS DECIMAL(10,2))) FROM STATION;