Weather Observation Station 15

Sort by

recency

|

2204 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

    In MS Sql server:

    select Format(LONG_W, '0.####') from station where LAT_N = (select max(LAT_N) from station where LAT_N < 137.2345)

  • + 0 comments

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

  • + 0 comments

    SELECT TOP 1 CAST(LONG_W AS DECIMAL(10,4)) FROM STATION WHERE LAT_N < 137.2345 ORDER BY LAT_N DESC

  • + 0 comments

    SELECT cast(ROUND(LONG_W, 4) as decimal(10,4)) FROM STATION WHERE LAT_N <137.2345 ORDER BY LAT_N DESC LIMIT 1;