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
+ 1 comment sql server
SELECT CAST(ROUND(SUM(LAT_N), 2) AS DECIMAL(18,2)) AS LAT, CAST(ROUND(SUM(LONG_W), 2) AS DECIMAL(18,2)) AS LON FROM STATION;
+ 0 comments select round(sum(LAT_N),2),round(sum(LONG_W),2) from STATION ;
+ 0 comments my sqlServer solution
SELECT ROUND(SUM(LAT_N),2) as Lat, ROUND(SUM(LONG_W),2) as lon FROM STATION
+ 0 comments MySql solution
SELECT ROUND(SUM(LAT_N),2),ROUND(SUM(LONG_W),2) FROM STATION;
+ 1 comment works in MySql:
select round(sum(lat_n),2),round(sum(long_w),2) from station;
Load more conversations
Sort 1166 Discussions, By:
Please Login in order to post a comment