select CITY from STATION order by Length(CITY) asc, CITY asc FETCH NEXT 1 ROW ONLY; Hİ guys ı tried to work this code and I managed to get it working by "pgADMİN4" Program but I can't manage to work this code here. why couldn't me

(https://photos.app.goo.gl/UFBJvpPtkbzMPdgZ6)

Here are the solution of Weather Observation Station 5 in SQL Hacker Rank Solution https://www.chase2learn.com/weather-observation-station-5-in-sql-hacker-rank-solution/

select city, length(city) from (select * from station order by length(city) asc, city asc) where rownum = 1;

select city, length(city) from (select * from station order by length(city) desc, city asc) where rownum = 1;

I run it on oracle, so i use 'rownum' instead of 'limit'

SELECT CITY,LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY ASC LIMIT 1;

SELECT CITY,LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1;

SELECT * FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC) WHERE ROWNUM = 1 UNION ALL SELECT * FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC) WHERE ROWNUM = 1;