列表如下 SELECT CITY FROM STATIONWHERE SUBSTR(CITY, 1,1) NOT IN ('A','E','I','O','U')GROUP BY CITY; 转载于:https://www.cnblogs.com/Angella/p/6680348.html