Weather Observation Station 15

Sort by

recency

|

2168 Discussions

|

  • + 0 comments

    SELECT round(LONG_W,4) FROM station WHERE LAT_N IN (SELECT MAX(LAT_N) FROM station WHERE LAT_N < 137.2345);

    TRICKY ONE BUT LOVED SOLVING IT

  • + 0 comments
    SELECT TOP 1 CAST(LONG_W as DECIMAL(7,4))
    FROM STATION
    WHERE LAT_N < 137.2345
    ORDER BY LAT_N DESC
    
  • + 0 comments

    select round(LONG_W,4) from station where LAT_N<137.2345 order by LAT_N desc limit 1;

  • + 0 comments

    oracle: SELECT ROUND(LONG_W, 4) FROM STATION WHERE LAT_N = (SELECT MAX(LAT_N) FROM STATION WHERE LAT_N < 137.2345);

  • + 0 comments

    SELECT ROUND(LONG_W,4) FROM STATION WHERE LAT_N < 137.2345 ORDER BY LAT_N DESC limit 1;