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
|
1501 Discussions
|
Please Login in order to post a comment
SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2) FROM STATION;
When ROUND func doesn't work due to precision issues, cast into DECIMAL type:
select cast(sum(lat_n) as decimal(10,2)),cast(sum(long_w) as decimal(10,2)) from station
select round(sum(LAT_N),2),round(sum(LONG_W),2) from station;
SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2) FROM STATION;
select concat(round(sum(lat_n),2),' ',round(sum(long_w),2)) from station or don't use concat..