Weather Observation Station 11
Weather Observation Station 11
+ 0 comments MySQL select distinct city from station where city regexp '^[^aeiou].*[^aeiou]$';
+ 0 comments FOR ORACLE:
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')));
+ 0 comments SELECT DISTINCT city FROM station WHERE left(city, 1) NOT IN ('A', 'E', 'I', 'O', 'U') OR right(city, 1) NOT IN ('a', 'e', 'i', 'o', 'u');
THIS ONE IS CORRECT
+ 0 comments MS SQL SERVER
11TH ANSWER select distinct(city) from station where city not like '[aeiou]%' or city not like '%[aeiou]'
+ 1 comment SQL SERVER
SELECT DISTINCT City FROM Station WHERE LEFT(City,1) NOT LIKE '%[aeiou]' OR RIGHT(City,1) NOT LIKE '%[aeiou]'
Sort 2783 Discussions, By:
Please Login in order to post a comment