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

|

2526 Discussions

|

  • geetanjali_godi1
     + 0 comments

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

  • muskanj3108
     + 0 comments

    SELECT cast(ROUND(ABS(MIN(lat_n) - MAX(lat_n)) + ABS(MIN(long_w) - MAX(long_w)), 4) as decimal(10,4)) as result FROM station;

  • fabricio_2310
     + 0 comments
    

    SELECT 
    ROUND(ABS(MIN(lat_n) - MAX(lat_n)) + 
    ABS(MIN(long_w) - MAX(long_w)), 4) as result
FROM station;

  • m69angel21
     + 0 comments

    Hi, this is my option in mysql:

    WITH distance AS ( SELECT MIN(lat_n) AS a ,MIN(long_w)AS b ,MAX(lat_n) AS c ,MAX(long_w) AS d FROM STATION ) SELECT round((c-a) + (d-b),4) FROM distance

  • chaitanyanair93
     + 0 comments

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