Weather Observation Station 2

Sort by

recency

|

1467 Discussions

|

  • + 0 comments

    MYSQL: select round(sum(Lat_N),2), round(sum(Long_w),2) from station;

  • + 0 comments

    SELECT ROUND(SUM(LATN), 2), ROUND(SUM(LONGW), 2) FROM STATION;

    **(IF THIS QUERY DOESN'T WORK SMH) Try this:

    SELECT CAST(ROUND(SUM(LAT_N), 2) AS DECIMAL(10,2)), CAST(ROUND(SUM(LONG_W), 2) AS DECIMAL(10,2)) FROM STATION;

    CAST FORCES THE OUTPUT TO SHOW ONLY 2 DECIMALS

  • + 0 comments

    MySQL :

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

  • + 0 comments

    For MYSQL

    SELECT 
        round(SUM(LAT_N),2),
        round(SUM(LONG_W),2)
    FROM STATION
    ;
    
  • + 0 comments

    SELECT CAST(ROUND(SUM(LAT_N),2) AS DECIMAL(20,2)), CAST(ROUND(SUM(LONG_W),2) AS DECIMAL(20,2)) FROM STATION