-
Weather Observation Station 6 MySQLHackerRank/SQL 2023. 2. 9. 15:07
문제
https://www.hackerrank.com/challenges/weather-observation-station-6/problem
Weather Observation Station 6 | HackerRank
Query a list of CITY names beginning with vowels (a, e, i, o, u).
www.hackerrank.com
풀이
- LIKE 조건을 여러 개 사용하고 싶을 경우 REGEXP를 사용한다.
SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiou]''HackerRank > SQL' 카테고리의 다른 글
Binary Tree Nodes MySQL (0) 2023.02.11 Occupations MySQL (0) 2023.02.10 The PADS MySQL (0) 2023.02.10 The Report MySQL (0) 2023.02.09 Weather Observation Station 4 MySQL (0) 2023.02.08