Weather Observation Station 15

Sort by

recency

|

2181 Discussions

|

  • + 0 comments

    **> 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;
    
  • + 0 comments

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

  • + 0 comments

    My code:

    SELECT 
        ROUND(long_w, 4)
    FROM station
    WHERE lat_n < 137.2345
    ORDER BY lat_n DESC
    LIMIT 1;
    

    OR

    SELECT ROUND(long_w, 4) FROM station WHERE lat_n = ( SELECT MAX(lat_n) FROM station WHERE lat_n < 137.2345 ) ;

  • + 0 comments

    MySQL

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