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 13
Weather Observation Station 13
Sort by
recency
|
1601 Discussions
|
Please Login in order to post a comment
select cast(t.total_sum as decimal(30,4)) from (SELECT SUM(LAT_N) as total_sum FROM Station WHERE LAT_N > '38.7880' AND LAT_N < '137.2345') t;
SELECT TO_CHAR(ROUND(SUM(LAT_N), 4), '99990.0000') FROM STATION WHERE LAT_N BETWEEN 38.7880 AND 137.2345;
THIS WILL BE GIVE YOU THE CORRECT ANSWER
Easy query:
SELECT ROUND(SUM(LAT_N), 4) FROM Station WHERE LAT_N > '38.7880' AND LAT_N < '137.2345'
select round(sum(LAT_N),4) from station where LAT_N>38.7880 and LAT_N<137.2345;
you can use the truncate or round off ,as per your preference