You are viewing a single comment's thread. Return to all 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;
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
If you want use rownum, you should rewrite code like this