반응형 mysql regexp7 [MySQL] Weather Observation Station 6 ▶ SQL > Basic Select > Weather Observation Station 6 Problem Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. → 중복X The STATION table is described as follows: My Answer 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%') SELECT DISTINCT CITY .. 2021. 4. 1. 이전 1 2 다음 반응형
