列表如下
SELECT CITY FROM STATIONWHERE SUBSTR(CITY, 1,1) NOT IN (‘A‘,‘E‘,‘I‘,‘O‘,‘U‘)GROUP BY CITY;
sql 查询city名字开头不含元音字母
原文:http://www.cnblogs.com/Angella/p/6680348.html