Weather Observation Station 10

Sort by

recency

|

2234 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 CITY NOT LIKE '%a' AND CITY NOT LIKE '%e' AND CITY NOT LIKE '%i' AND CITY NOT LIKE '%o' AND CITY NOT LIKE '%u';

  • + 0 comments

    select distinct city from station where city regexp '[^aeiou]$';

  • + 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 REGEXP_LIKE(city, '[AEIOU]$') = 0 ;