|
1
2
3
4
5
6
7
8
|
select city
from station
where
left(city,1)='a' or
left(city,1)='e' or
left(city,1)='i' or
left(city,1)='o' or
left(city,1)='u'
|
cs |
left 함수는 문자열 다루는 함수구요
left(변수명, 글자수)
변수명 의 글자수 왼쪽만큼을 return 합니다
반응형
'SQL' 카테고리의 다른 글
| Hacker rank Weather Observation Station 8 (0) | 2021.10.20 |
|---|---|
| Hacker rank Weather Observation Station 7 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 5 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 4 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 3 (0) | 2021.10.20 |
댓글