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 1860 Discussions, By:

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

  • raftaarrashedin1
     + 0 comments
    select abs(round((min(lat_n)-max(lat_n)) +(min(long_w)-max(long_w)),4)) from station;

  • arjunbindra2
     + 1 comment

    the expected output is 259.6859 but mine is coming out to be 259.68590000. That must be the reason for the error, I suppose. Although I have tried using Trim (trailing '0'), but does't work. Any suggestions?

    select Round(abs(max(lat_n)-min(lat_n))+abs(max(long_w)-min(long_w)),4) as distance from station;

  • omkarthorve_ot
     + 0 comments

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

  • aishwarya_nair_1
     + 0 comments

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

Load more conversations