We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 8
Weather Observation Station 8
Sort by
recency
|
3853 Discussions
|
Please Login in order to post a comment
MS SQL SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE'[A,E,I,O,U]%[A,E,I,O,U]'
WHERE HAVE I GONE WRONG CAN ANYONE POINT OUT MY MISTAKE
WITH LEFT_CITIES AS ( SELECT DISTINCT CITY FROM STATION WHERE UPPER(LEFT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U') ), RIGHT_CITIES AS ( SELECT DISTINCT CITY FROM STATION WHERE UPPER(RIGHT(CITY, 1)) IN ('A', 'E', 'I', 'O', 'U') )
SELECT LEFT_CITIES.CITY AS LEFT_CITY, RIGHT_CITIES.CITY AS RIGHT_CITY FROM LEFT_CITIES, RIGHT_CITIES;
MySQL
select distinct city from station where right(city,1) in ('a','e','i','o','u') and left(city,1) in ('a','e','i','o','u');
SELECT DISTINCT city FROM station WHERE UPPER(SUBSTR(city, 1, 1)) IN ('A', 'E', 'I', 'O', 'U') AND UPPER(SUBSTR(city, -1, 1)) IN ('A', 'E', 'I', 'O', 'U');
SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[a,e,i,o,u]+(.)+[a,e,i,o,u]$';