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.
To find unique city names in the STATION table that start and end with a vowel, you can use the following query:
SELECT DISTINCT CITY
FROM STATION
WHERE RIGHT(CITY, 1) IN ('a','i','e','o','u')
AND LEFT(CITY, 1) IN ('A','E','I','O','U');
Just like this SQL query filters data with precision, professional CV writing services London UK help filter and highlight the best details of your career to make your profile stand out.
Weather Observation Station 8
You are viewing a single comment's thread. Return to all comments →
To find unique city names in the STATION table that start and end with a vowel, you can use the following query: SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY, 1) IN ('a','i','e','o','u') AND LEFT(CITY, 1) IN ('A','E','I','O','U');
Just like this SQL query filters data with precision, professional CV writing services London UK help filter and highlight the best details of your career to make your profile stand out.