-
[HackerRank/Basic Select] Weather Observation Station 9공부/PS ( SQL) 2022. 5. 16. 00:02
https://www.hackerrank.com/challenges/weather-observation-station-9/problem
문제
풀이
SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "^[^aeiou]"
- 정규표현식으로 ^[^aeiou] 를 사용하여 a,e,i,o,u로 시작하지 않는 값들을 찾아주었다.
'공부 > PS ( SQL)' 카테고리의 다른 글
[HackerRank/Basic Select] Weather Observation Station 11 (0) 2022.05.16 [HackerRank/Basic Select] Weather Observation Station 10 (0) 2022.05.16 MYSQL 정규표현식 (0) 2022.05.15 [HackerRank/Basic Select] Weather Observation Station 8 (0) 2022.05.15 [HackerRank/Basic Select] Weather Observation Station 7 (0) 2022.05.15