We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Weather Observation Station 19
  5. Discussions

Weather Observation Station 19

Sort by

recency

|

2413 Discussions

|

  • augustorodrigue1
     + 0 comments
    DECLARE @B FLOAT;
DECLARE @C FLOAT;
DECLARE @D FLOAT;

SELECT @A = MIN(LAT_N),
        @B = MAX(LAT_N),
        @C = MIN(LONG_W),
        @D = MAX(LONG_W)
FROM STATION

SELECT CAST(SQRT(POWER(@A-@B,2) + POWER(@C-@D,2)) AS DECIMAL(10,4))

  • h24022399
     + 0 comments
    SELECT ROUND(SQRT((MIN(LAT_N)-MAX(LAT_N))*(MIN(LAT_N)-MAX(LAT_N)) + (MIN(LONG_W)-MAX(LONG_W))*(MIN(LONG_W)-MAX(LONG_W))), 4)
FROM STATION

  • jhasomil15
     + 0 comments

    WITH DIST AS ( SELECT MIN(LAT_N) AS A ,MIN(LONG_W) AS C, MAX(LAT_N) AS B, MAX(LONG_W) AS D FROM STATION)

    SELECT ROUND( SQRT( POW(B-A,2)+ POW(D-C,2) ) ,4 ) FROM DIST;

  • abhishek_pujari
     + 0 comments

    My SQL

    CREATE VIEW positions 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(POWER(ABS(a-b),2) + POWER(ABS(c-d),2)),4) AS Euclidean_Distance FROM positions;

  • S_tnieks
     + 0 comments

    SQL SERVER 

    SELECT
CAST(
    SQRT(
        POWER(((
            SELECT TOP 1 lat_n 
            FROM station 
            ORDER BY lat_n ASC)
            -
            (
            SELECT TOP 1 lat_n 
            FROM station
            ORDER BY lat_n DESC
            )), 2)
        +
        POWER(((
            SELECT TOP 1 long_w
            FROM station
            ORDER BY long_w ASC)
            -
            (
            SELECT TOP 1 long_w
            FROM station
            ORDER BY long_w DESC
            )), 2)
        ) 
    AS DECIMAL(10,4));