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 18
  5. Discussions

Weather Observation Station 18

Sort by

recency

|

2536 Discussions

|

  • fmunoz1
     + 0 comments
    SELECT
  DECIMAL(
    ROUND(ABS(a - c) + ABS(b - d), 4),
    10, 4
  )
FROM (
  SELECT
    MIN(lat_n) AS a,
    MIN(long_w) AS b,
    MAX(lat_n) AS c,
    MAX(long_w) AS d
  FROM Station
);

  • srujangirish1124
     + 0 comments

    SELECT DECIMAL(ROUND(ABS(MAX(LAT_N)-MIN(LAT_N))+ABS(MAX(LONG_W)-MIN(LONG_W)),4),10,4) FROM STATION;

  • vmali3318
     + 0 comments

    SELECT ROUND(ABS(MAX(LAT_N)-MIN(LAT_N))+ABS(MAX(LONG_W)-MIN(LONG_W)),4) FROM STATION;

  • nurliyanashukur
     + 0 comments
    WITH TotalManDis AS (
    select 
        MIN(LAT_N) AS min_latn,
        MIN(LONG_W) AS min_longW,
        MAX(LAT_N) AS max_latn,
        MAX(LONG_W) AS max_longw
    from STATION
)
SELECT 
    CAST(ABS(min_latn - max_latn) + ABS(min_longW - max_longw) AS DECIMAL(10,4))
FROM TotalManDis;

  • tu_anh_anh_81299
     + 0 comments

    SET NOCOUNT ON;

    SELECT CAST (ROUND(ABS((MIN(LAT_N)-MAX(LAT_N))+(MIN(LONG_W)-MAX(LONG_W))),4) AS DECIMAL(10,4)) FROM STATION;

    go