Weather Observation Station 10

Sort by

recency

|

2125 Discussions

|

  • + 0 comments

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

    Oracle SQL: SELECT DISTINCT CITY FROM STATION WHERE 1=1 AND NOT REGEXP_LIKE(CITY,'[AEIOU]$','i')

  • + 0 comments

    MS SQL SERVER:

    select distinct city from station 
    where RIGHT(CITY, 1) NOT IN ('a','A','e','E','i','I','o', 'O','u','U')
    
  • + 0 comments
    select distinct city from station where city regexp '^[^AEIOU]'
    
  • + 0 comments

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

  • + 0 comments

    select distinct(city) from station where lower(city) not like '%a' and city not like '%e' and city not like '%i' and city not like '%o' and city not like '%u';