Weather Observation Station 19

Sort by

recency

|

2352 Discussions

|

  • + 0 comments

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

  • + 0 comments

    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

    MS SQL Server:

    Select Format(Round(Sqrt((Power((Min(s.LAT_N)-Max(s.LAT_N)),2) + Power((Min(s.LONG_W)-Max(s.LONG_W)),2))),4), '0.####') From STATION s;

  • + 0 comments
    SELECT TRUNCATE(SQRT(POW(MIN(LAT_N) - MAX(LAT_N), 2) + POW(MIN(LONG_W) - MAX(LONG_W), 2)), 4)
    FROM STATION;
    
  • + 0 comments

    ** THIS QUESTION I AM DOING WITH CTE BUT SOME SYNTAX MISTAKE I DID FIX WITH THE HELP CHATGPT *

    WITH VALUES_FIND AS ( SELECT MIN(LAT_N) AS A, MAX(LAT_N) AS B, MIN(LONG_W) AS C, MAX(LONG_W) AS D FROM STATION ) SELECT ROUND(SQRT(POW(B - A, 2) + POW(D - C, 2)), 4) FROM VALUES_FIND;