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 8
Weather Observation Station 8
Sort by
recency
|
4732 Discussions
|
Please Login in order to post a comment
oracle select distinct city from station where REGEXP_LIKE(city,'^[aeiou].*[aeiou]$','i');
// i is for insensitive matching.
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%') and ( CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u');
SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[aeiouAEIOU]$' AND CITY REGEXP '^[aeiouAEIOU]';
select distinct city from station where (lower(right(city,1))in ('a', 'e','i', 'o', 'u')) and (lower(left(city,1)) in ('a', 'e','i', 'o', 'u'))