Given a table STATION that holds data for five fields namely ID, CITY, STATE, NORTHERN LATITUDE and WESTERN LONGITUDE.
+-------------+------------+| Field | Type |+-------------+------------+| ID | INTEGER || CITY | VARCHAR(21)|| STATE | VARCHAR(2) || LAT_N | NUMERIC || LONG_W | NUMERIC |+-------------+------------+>>select distinct city from station where (city not like '%a' and city not like '%e' and city not like '%i' and city not like '%o' and city not like '%u') or (city not like 'a%' and city not like 'e%' and city not like 'i%' and city not like 'o%' and city not like 'u%') order by city;
Thanks.
No comments:
Post a Comment