You are viewing a single comment's thread. Return to all comments →
SELECT cast(SUM(LAT_N) as decimal(10,2))as lat, cast(SUM(LONG_W)as decimal(10,2)) as lon FROM Station;
The decimal function cuts the decimal points upto 2 so, we will get the right ans
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 2
You are viewing a single comment's thread. Return to all comments →
SELECT cast(SUM(LAT_N) as decimal(10,2))as lat, cast(SUM(LONG_W)as decimal(10,2)) as lon FROM Station;
The decimal function cuts the decimal points upto 2 so, we will get the right ans