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 lower(substr(CITY,1,1)) in ('a','e','i','o','u') ;
Source by hoojiv.tistory.com #
 
PREVIOUS NEXT
Tagged: #Query #list #CITY #names #starting #vowels #Your #result
ADD COMMENT
Topic
Name
3+4 =