Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.

SELECT DISTINCT CITY
FROM STATION 
WHERE REGEXP_LIKE(CITY, '^[aeiouAEIOU]')
ORDER BY CITY
Source by hoojiv.tistory.com #
 
PREVIOUS NEXT
Tagged: #Query #list #CITY #names #starting #vowels #Your #result
ADD COMMENT
Topic
Name
9+2 =