반응형
Weather Observation Station 7 | HackerRank
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION.
www.hackerrank.com
$: ~로 끝나는지
[]: 범위에 들어가는지
정규식을 사용하여 해결하였습니다.
SELECT DISTINCT city
FROM station
WHERE city REGEXP '[aeiou]$'반응형
'Database' 카테고리의 다른 글
| Weather Observation Station 9 [ MySql ] (0) | 2021.12.07 |
|---|---|
| Weather Observation Station 8 [ MySql ] (0) | 2021.12.07 |
| Weather Observation Station 6 [ MySql ] (0) | 2021.12.07 |
| Department Top Three Salaries [ MSSQL ] (0) | 2021.12.06 |
| Department Highest Salary [ MSSQL ] (0) | 2021.12.06 |