Weather Observation Station 15

Sort by

recency

|

2195 Discussions

|

  • + 0 comments
    select cast(long_w 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 );
    This doesn't work can anyone plz help

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