Weather Observation Station 12

Sort by

recency

|

2415 Discussions

|

  • + 0 comments

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

  • + 0 comments

    MS SQL

    SELECT DISTINCT (CITY) 
    FROM STATION 
    WHERE CITY NOT LIKE "[a,e,i,o,u]%"  
    AND CITY NOT LIKE "%[a,e,i,o,u]";
    
  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE LOWER(LEFT(CITY, 1)) NOT IN ('a', 'e', 'i', 'o', 'u') AND LOWER(RIGHT(CITY, 1)) NOT IN ('a', 'e', 'i', 'o', 'u');

  • + 0 comments

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

  • + 0 comments

    select distinct city from station where city NOT REGEXP '^[aeiouAEIOU].$' and city NOT REGEXP'^.[aeiouAEIOU]$'