Weather Observation Station 16

Sort by

recency

|

1079 Discussions

|

  • + 0 comments

    SELECT MIN(ROUND(LAT_N ,4)) FROM station WHERE LAT_N > 38.7780; DO THE roundoff first then find min , if getting error

  • + 0 comments

    SELECT ROUND(LAT_N,4) FROM STATION WHERE LAT_N > 38.7780 ORDER BY LAT_N ASC LIMIT 1;

  • + 3 comments

    SELECT ROUND(MIN(LAT_N), 4) FROM STATION WHERE LAT_N > 38.7780; I did this but its giving me wrong answer .anyone who can help?

  • + 0 comments

    select top 1 cast(lat_n as decimal(10,4)) from station
    where lat_n > 38.7780 order by lat_n ;

  • + 0 comments

    MySQL:

    select round(LAT_N,4) from STATION where LAT_N >38.7780 order by LAT_N ASC LIMIT 1;