You are viewing a single comment's thread. Return to all comments →
SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE (CITY, '^[^AEIOU]','i');
For oracle
Weather Observation Station 9
You are viewing a single comment's thread. Return to all comments →
SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE (CITY, '^[^AEIOU]','i');
For oracle