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 
GROUP BY city HAVING LEFT(city, 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
2+1 =