Weather Observation Station 15

Sort by

recency

|

2193 Discussions

|

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments

    MySQL

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

  • + 0 comments

    SELECT CAST(ROUND(long_w, 4) AS DECIMAL(10,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
    

    OUTPUT: 117.2465