Weather Observation Station 10

Sort by

recency

|

2129 Discussions

|

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments

    SELECT DISTNICT CITY FROM STATION WHERE NOT(CITY LIKE '%A OR CITY LIKE '%I OR CITY LIKE '%U OR CITY LIKE '%O OR CITY LIKE '%U);

  • + 0 comments

    in oracle select distinct city from station where not regexp_like(city,'.*[aeiou]$','i');

  • + 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')