Weather Observation Station 18

Sort by

recency

|

2493 Discussions

|

  • + 0 comments

    MySQL

    SELECT ROUND((MAX(LAT_N)-MIN(LAT_N)),4) + ROUND((MAX(LONG_W)-MIN(LONG_W)),4) FROM STATION ;

  • + 0 comments

    SELECT ROUND(MAX(LAT_N)-MIN(LAT_N) + MAX(LONG_W)-MIN(LONG_W),4)

    FROM STATION

  • + 0 comments

    SELECT ROUND(ABS(A - C) + ABS(B - D),4) AS MD FROM ( SELECT MIN(LAT_N) AS A, MAX(LAT_N) AS C, MIN(LONG_W) AS B, MAX(LONG_W) AS D FROM STATION ) AS sub;

  • + 0 comments

    MySQL

    SELECT ROUND(((MAX(LAT_N)-MIN(LAT_N))+(MAX(LONG_W)-MIN(LONG_W))), 4) FROM STATION;

  • + 0 comments

    -- so basicaly: |x1 - x2| + |y1 - y2| select cast(abs(min(lat_n) - max(lat_n)) as decimal (38,4)) + cast(abs(min(long_w) - max(long_w)) as decimal (38,4)) from station