Weather Observation Station 5

  • + 3 comments

    what is the need of 'city' after lenght(city) in the statement? similary after length(city) desc, city.. why ? SELECT * FROM(SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY),CITY) WHERE ROWNUM = 1; SELECT * FROM(SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC,CITY) WHERE ROWNUM = 1;