Weather Observation Station 19

Sort by

recency

|

2361 Discussions

|

  • + 0 comments

    select round(sqrt(power(max(lat_n),2) - power(min(lat_n),2) + power(max(long_w),2) - power(min(long_w),2)),4) +----------+ | distance | +----------+ | 105.3135 | +----------+

  • + 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;