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

select truncate(long_w, 4) from station where lat_n = ( select max(lat_n) from station where lat_n < 137.2345 );

anyone please show me the problem here....

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

This gets around having aggregate and non aggregate without a GROUP BY as MY SQL defaults to ONLY_FULL_GROUP_BY which means you can't just use HAVING to treat the single query as a group

SELECT CAST(ROUND(LONG_W , 4) AS DECIMAL(10,4)) FROM STATION WHERE LAT_N<137.2345 ORDER BY LAT_N DESC LIMIT 1; IT WORKS

SQL SERVER

SELECT TOP 1 CAST(long_w AS DECIMAL(10,4))
FROM station
WHERE lat_n < 137.2345
ORDER BY lat_n DESC;