We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
I just post my solution to give some ideas to solve this problem in mysql:
Select round(S.LAT_N,4) mediam
from station S
where (select count(Lat_N) from station where Lat_N < S.LAT_N ) = (select count(Lat_N) from station where Lat_N > S.LAT_N)
Weather Observation Station 20
You are viewing a single comment's thread. Return to all comments →
I just post my solution to give some ideas to solve this problem in mysql: Select round(S.LAT_N,4) mediam from station S where (select count(Lat_N) from station where Lat_N < S.LAT_N ) = (select count(Lat_N) from station where Lat_N > S.LAT_N)