We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 7
Weather Observation Station 7
Sort by
recency
|
2703 Discussions
|
Please Login in order to post a comment
By using regular expression
select distinct city from station where right(city,1) in ('a','e','i','o','u');
SELECT city FROM station WHERE city IS NOT NULL AND lower(substr(city, 1, 1)) IN ('a', 'e', 'i', 'o', 'u');
SELECT DISTINCT city FROM STATION WHERE REGEXP_LIKE(CITY,'A|I|U$','i');
SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[aeiou]$';