목록length (1)

조컴퓨터

hackerrank Weather Observation Station 5

1) 짧은 도시명 1-1) SELECT city, LENGTH(city) FROM STATION ORDER BY LENGTH(city), city; 1-1) 결과 1-2) SELECT * FROM ( SELECT city, LENGTH(city) FROM STATION ORDER BY LENGTH(city), city ) WHERE rownum = 1; 1-2) 결과 2) 가장 긴 도시명 2-1) SELECT city, LENGTH(city) FROM STATION ORDER BY LENGTH(city) DESC, city DESC; 2-1) 결과 2-2) SELECT * FROM ( SELECT city, LENGTH(city) FROM STATION ORDER BY LENGTH(city) DESC, ..
HackerRank/SQL 2021. 1. 31. 00:05
이전 Prev 1 Next 다음