Weather Observation Station 19

Sort by

recency

|

2342 Discussions

|

  • + 0 comments

    MySQL

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

  • + 0 comments

    SELECT ROUND(SQRT(POWER(A-B,2) + POWER(C-D,2)),4) AS ED FROM ( SELECT MIN(LAT_N) AS A, MAX(LAT_N) AS B, MIN(LONG_W) AS C, MAX(LONG_W) AS D FROM STATION ) AS VAL

  • + 0 comments

    -- formula: √((x₂ - x₁)² + (y₂ - y₁)²) select cast( SQRT( power(max(lat_n) - min(lat_n),2) + power(max(long_w) - min(long_w),2) ) as decimal (38,4)) from station

  • + 0 comments

    select round(sqrt((abs((select min(lat_n) from station) - (select max(lat_n) from station))(abs((select min(lat_n) from station) - (select max(lat_n) from station))))+ (abs((select min(long_w) from station) - (select max(long_w) from station))(abs((select min(long_w) from station) - (select max(long_w) from station))))),4) from station limit 1;

  • + 0 comments
    **select Round(
        sqrt(
        pow(max(lat_n)-min(lat_n),2)
            +
        pow(max(long_w)-min(long_w),2)
    )
        ,4) 
    from station;**