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
|
1494 Discussions
|
Please Login in order to post a comment
SELECT cast(ROUND(SUM(LAT_N), 2) AS decimal(10,2))as lat, cast(ROUND(SUM(LONG_W), 2) AS decimal(10,2))AS lon FROM STATION;
we have to use cast fun that exactly uses the decimal 2 places
SELECT round(sum(LAT_N) ,2) , round(sum(LONG_W),2) FROM station ;
SELECT ROUND(SUM(LAT_N),2)AS lat,ROUND(SUM(LONG_W),2)AS lon FROM STATION;
SELECT ROUND(SUM(LAT_N),2)AS lat,ROUND(SUM(LONG_W),2)AS lon FROM STATION;
SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W),2) FROM STATION;