Weather Observation Station 18

Sort by

recency

|

2508 Discussions

|

  • + 0 comments

    SELECT CAST( ABS(MIN(LAT_N)- MAX(LAT_N)) + ABS(MIN(LONG_W)- MAX(LONG_W)) AS DECIMAL (10,4) ) FROM STATION

  • + 0 comments
    SELECT ROUND(ABS(MIN(LAT_N)-MAX(LAT_N))+ABS(MIN(LONG_W)-MAX(LONG_W)),4) FROM STATION
    
  • + 0 comments

    select round((abs(a-c)+abs(b-d)),4) from( select (select min(lat_n) from station) as a, (select min(long_w) from station) as b, (select max(lat_n) from station) as c, (select max(long_w) from station) as d ) as t;

    if you want to do by defing each variable, otherwise u can use manhattan formula directly.

  • + 0 comments

    select round(abs(min(LAT_N)-max(LAT_N))+abs(min(long_w)-max(long_w)),4) from station;

  • + 0 comments

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