Weather Observation Station 19

Sort by

recency

|

2360 Discussions

|

  • + 0 comments

    Two dimensions

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

  • + 0 comments

    Orale sample

    WITH ps AS ( 
        SELECT
            min(lat_n) x1, 
            min(long_w) y1,
            max(lat_n) x2, 
            max(long_w) y2 
        FROM station)
    SELECT
        round(
            SQRT(
                POWER((x2-x1),2)
                +POWER((y2-y1),2)
                )
            ,4) euclidean_distance
    FROM ps;
    
  • + 0 comments

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

  • + 0 comments

    SELECT cast( SQRT( POWER(ROUND(MAX(lat_n) - MIN(lat_n), 4), 2) + POWER(ROUND(MAX(long_w) - MIN(long_w), 4), 2) ) AS decimal(10,4)) FROM station;

  • + 0 comments
    • a = MIN(LAT_N)
    • b = MAX(LAT_N)
    • c = MIN(LONG_W)
    • d = MAX(LONG_W)
    • Euclidean Distance = SQRT[(b-a)^2 + (d-c)^2]
    SELECT
        ROUND(SQRT(
            POWER(MAX(LAT_N) - MIN(LAT_N), 2)
            + POWER(MAX(LONG_W) - MIN(LONG_W), 2)
        ), 4)
    FROM STATION
    

    OUTPUT: 184.1616