Weather Observation Station 8

Sort by

recency

|

4732 Discussions

|

  • + 0 comments
    SELECT DISTINCT(CITY)
    FROM STATION
    WHERE LEFT(CITY,1)IN ("a","e","i","o","u") AND  RIGHT(CITY,1) IN ("a","e","i","o","u");
    
  • + 0 comments

    oracle select distinct city from station where REGEXP_LIKE(city,'^[aeiou].*[aeiou]$','i');

    // i is for insensitive matching.

  • + 0 comments

    select DISTINCT CITY FROM STATION WHERE (CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE 'I%' OR CITY LIKE 'O%' OR CITY LIKE 'U%') and ( CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u');

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[aeiouAEIOU]$' AND CITY REGEXP '^[aeiouAEIOU]';

  • + 0 comments

    select distinct city from station where (lower(right(city,1))in ('a', 'e','i', 'o', 'u')) and (lower(left(city,1)) in ('a', 'e','i', 'o', 'u'))