Weather Observation Station 2

Sort by

recency

|

1494 Discussions

|

  • + 0 comments

    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

  • + 0 comments

    SELECT round(sum(LAT_N) ,2) , round(sum(LONG_W),2) FROM station ;

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments

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