728x90
a,e,i,o,u 로 끝나는 city 를 출력하는 문제이고, 추가로 중복없이 출력해야한다.
정답 : select distinct city from station
where (city like '%a'
or city like '%e'
or city like '%i'
or city like '%o'
or city like '%u');
728x90
'Algorithm & SQL > SQL' 카테고리의 다른 글
Weather Observation Station 9 (0) | 2022.06.08 |
---|---|
Weather Observation Station 8 (regexp 사용) (0) | 2022.06.07 |
Weather Observation Station 6 (regexp) (0) | 2022.06.07 |
Weather Observation Station 5 (0) | 2022.06.07 |
Weather Observation Station 4 (0) | 2022.06.07 |
댓글