You are viewing a single comment's thread. Return to all comments →
For Oracle
SELECT DISTINCT CITY FROM STATION WHERE SUBSTR(CITY,LENGTH(CITY),LENGTH(CITY)) IN ('a','i','e','o','u');
For MySql
SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) IN ('a','i','e','o','u');
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 7
You are viewing a single comment's thread. Return to all comments →
For Oracle
For MySql