Weather Observation Station 8

Sort by

recency

|

4525 Discussions

|

  • + 2 comments

    select distinct city from station where (lower(city) like 'a%' and lower(city) like '%a') or (lower(city) like 'e%' and lower(city) like '%e') or (lower(city) like 'i%' and lower(city) like '%i') or (lower(city) like 'o%' and lower(city) like '%o') or (lower(city) like 'u%' and lower(city) like '%u') order by city; I am getting output but it is displaying that it is wrong

  • + 0 comments

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

  • + 0 comments

    MS SQL SERVER:

    select distinct city from station 
    where LEFT(CITY, 1) IN ('a','A','e','E','i','I','o', 'O','u','U') and
    RIGHT(CITY, 1) IN ('a','A','e','E','i','I','o', 'O','u','U')
    
  • + 0 comments

    select distinct city from station where city REGEXP '^[a,e,i,o,u]' and city Regexp '[a,e,i,o,u]$'

  • + 0 comments

    MYSQL select distinct city from station where city regexp '^(a|e|i|o|u).*(a|e|i|o|u)$';