반응형
Weather Observation Station 8 | HackerRank
Query CITY names that start AND end with vowels.
www.hackerrank.com
^: ~로 시작
$: ~로 끝
.*: 어떤 글자가 없거나 하나 이상 있거나
[]: 범위안에 들어있는가
SELECT DISTINCT city FROM station WHERE city REGEXP '^[aeiou].*[aeiou]$'반응형
'Database' 카테고리의 다른 글
| Nth Highest Salary [ MySql ] (0) | 2021.12.07 |
|---|---|
| Weather Observation Station 9 [ 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 |