Weather Observation Station 15

Sort by

recency

|

2144 Discussions

|

  • + 0 comments

    MySQL:

    SELECT ROUND(LONG_W,4)
    FROM STATION
    WHERE LAT_N = (SELECT MAX(LAT_N) 
                                 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 = (SELECT MAX(LAT_N) FROM STATION WHERE LAT_N < 137.2345);

  • + 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;