You are viewing a single comment's thread. Return to all comments →
This also works:
select distinct CITY from STATION where lower(substr(CITY,1,1)) not in ('a','e','i','o','u');
Can you please tell me the difference in the substring function of the two solutions?
Sorry I am pretty new to this!
Weather Observation Station 9
You are viewing a single comment's thread. Return to all comments →
This also works:
select distinct CITY from STATION where lower(substr(CITY,1,1)) not in ('a','e','i','o','u');
Can you please tell me the difference in the substring function of the two solutions?
Sorry I am pretty new to this!