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.
select distinct city from (
(select city from station where city like '%a')
union all
(select city from station where city like '%e')
union all
(select city from station where city like '%i')
union all
(select city from station where city like '%o')
union all
(select city from station where city like '%u'));
Weather Observation Station 7
You are viewing a single comment's thread. Return to all comments →
This is how I did it in oracle.
select distinct city from ( (select city from station where city like '%a') union all (select city from station where city like '%e') union all (select city from station where city like '%i') union all (select city from station where city like '%o') union all (select city from station where city like '%u'));