반응형
Weather Observation Station 9 | HackerRank
Query an alphabetically ordered list of CITY names not starting with vowels.
www.hackerrank.com
모음으로 시작하는 정규식을 찾아
NOT 키워드를 사용해 걸렀습니다.
SELECT DISTINCT city
FROM station
WHERE city NOT REGEXP '^[aeiou]'반응형
'Database' 카테고리의 다른 글
| Nth Highest Salary [ MySql ] (0) | 2021.12.07 |
|---|---|
| Weather Observation Station 8 [ MySql ] (0) | 2021.12.07 |
| Weather Observation Station 7 [ MySql ] (0) | 2021.12.07 |
| Weather Observation Station 6 [ MySql ] (0) | 2021.12.07 |
| Department Top Three Salaries [ MSSQL ] (0) | 2021.12.06 |