반응형
Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.
Input Format
The STATION table is described as follows:
![](https://blog.kakaocdn.net/dn/mSCx9/btrEpA2Pgig/yPLovkoxKug9MwNIKURVd1/img.png)
select distinct city
From station
minus
select distinct city
from station
where regexp_like(city, '^[aeiou]', 'i');
select 두개 구문
전체중복 리스트에서 minus 연산자를 통해 aeiou로 시작하는 도시를 제외하여 결과값을 도출함
반응형
'TECH' 카테고리의 다른 글
Weather Observation Station 11 (0) | 2022.06.10 |
---|---|
Weather Observation Station 10 (0) | 2022.06.10 |
Weather Observation Station 8 (0) | 2022.06.10 |
Weather Observation Station 5 (0) | 2022.06.09 |
코로나19로 인한 국내 관광 행태 변화 분석 (0) | 2022.06.09 |