Weather Observation Station 12

Sort by

recency

|

2337 Discussions

|

  • + 0 comments

    MY SQL: SELECT DISTINCT CITY FROM STATION WHERE 1=1 AND RIGHT(CITY,1) NOT IN ('a','e','i','o','u') AND LEFT(CITY,1) NOT IN ('a','e','i','o','u')

  • + 0 comments

    Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE CITY NOT RLIKE '^[aeiou]' AND CITY NOT RLIKE'[aeiou]$'

  • + 2 comments

    SELECT DISTINCT city FROM station WHERE city NOT REGEXP '^[aeiou].*[aeiou]$'

    Could anyone confirm what is wrong with this query?

  • + 0 comments

    MS SQL SEVER :

    Select distinct(city) from station where city like '%[^a,e,i,o,u]' AND city like '[^a,e,i,o,u]%'