Weather Observation Station 8

Sort by

recency

|

4751 Discussions

|

  • + 0 comments
    SELECT DISTINCT CITY FROM STATION 
    WHERE CITY REGEXP '^[a,e,i,o,u].*[a,e,i,o,u]$'
    
  • + 0 comments

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

    why isnt this working?

  • + 0 comments

    SELECT DISTINCT(CITY) FROM STATION WHERE SUBSTR(CITY, 1,1) IN ('a', 'e', 'i', 'o', 'u') AND SUBSTR(CITY, -1, 1) IN ('a', 'e', 'i', 'o', 'u'); OR SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiou]' AND CITY REGEXP '[aeiou]$';

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE UPPER(LEFT, 1)) IN ('A', 'E', 'I', 'O', 'U') AND UPPER(RIGHT, 1)) IN ('A', 'E', 'I', 'O', 'U');

  • + 0 comments

    -- MS SQL server

    SELECT Distinct CITY FROM STATION WHERE CITY LIKE '[aeiou]%[aeiou]'