We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 8
  5. Discussions

Weather Observation Station 8

Sort by

recency

|

4484 Discussions

|

  • robertodark92
     + 0 comments

    /* Oracle */ SELECT city FROM station WHERE REGEXP_LIKE(city,'^[aeiou]', 'i') AND REGEXP_LIKE(city,'[aeiou]$', 'i');

  • SVVBathini
     + 0 comments

    For MySQL

    SELECT DISTINCT city FROM station
WHERE
    LEFT(city, 1) IN ("a","e","i","o","u")
    AND
    RIGHT(city, 1) IN ("a","e","i","o","u");

  • omkardesai171
     + 0 comments

    SQL Server select distinct city from station where SUBSTRING(LOWER(city),1,1) IN ('a','e','i','o','u') AND SUBSTRING(LOWER(city),LEN(city),LEN(city)) IN ('a','e','i','o','u');

  • jagadeeshmandal2
     + 0 comments

    with cte1 as ( select id,length(city)as l1 from station ) select distinct city from station s join cte1 as c1 on c1.id=s.id where substr(city,c1.l1,1)in ("a","e","i","o","u") and substr(city,1,1) in ("a","e","i","o","u")

  • aman_ansari2
     + 0 comments
    SELECT CITY FROM STATION 
WHERE 
UPPER(LEFT(CITY,1)) IN ('A','E','I','O','U')
AND 
UPPER(RIGHT(CITY,1)) IN ('A','E','I','O','U');