Weather Observation Station 10

Sort by

recency

|

2128 Discussions

|

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

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