Weather Observation Station 5

  • + 2 comments

    If you want use rownum, you should rewrite code like this

    SELECT * FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY)) WHERE ROWNUM <= 1;