Weather Observation Station 19

Sort by

recency

|

2336 Discussions

|

  • + 0 comments

    MySQL Solution:

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

  • + 0 comments

    select round(cast(sqrt(power(max(lat_n)-min(lat_n),2)+power(max(long_w)-min(long_w),2)) as decimal(10,4)),4) as distance from station

  • + 0 comments

    oracle:

    select round(sqrt(power((max(LAT_N)-min(LAT_N)), 2) + power((max(LONG_W)-min(LONG_W)), 2)), 4) from STATION;

  • + 0 comments

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

  • + 0 comments

    select round(sqrt((power((min(LAT_N)-max(LAT_N)),2))+(power((min(LONG_W)-max(LONG_W)),2))),4) from station;