Weather Observation Station 2

Sort by

recency

|

1501 Discussions

|

  • + 0 comments

    SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2) FROM STATION;

  • + 0 comments

    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

  • + 0 comments

    select round(sum(LAT_N),2),round(sum(LONG_W),2) from station;

  • + 0 comments

    SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2) FROM STATION;

  • + 0 comments

    select concat(round(sum(lat_n),2),' ',round(sum(long_w),2)) from station or don't use concat..