Weather Observation Station 15

Sort by

recency

|

2199 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 ORDER BY LAT_N DESC LIMIT 1;

  • + 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 ); in SQL server as round is giving 0000s after 4 decimals

  • + 0 comments

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

  • + 1 comment
    select cast(long_w as decimal(10,4)) from station where lat_n=(select max(lat_n) from station where lat_n<137.2345)