Weather Observation Station 6

Sort by

recency

|

4739 Discussions

|

  • + 1 comment

    SELECT DISTINCT city FROM station WHERE LOWER(SUBSTRING(city, 1, 1)) IN ('a', 'e', 'i', 'o', 'u');

  • + 1 comment

    SELECT DISTINCT city
    FROM station
    WHERE LEFT(city, 1) IN ('A', 'E', 'I', 'O', 'U');

  • + 0 comments

    SELECT DISTINCT city
    FROM station
    WHERE city LIKE 'A%'
    OR city LIKE 'E%'
    OR city LIKE 'I%'
    OR city LIKE 'O%'
    OR city LIKE 'U%';

     or  
    
  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE ( CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE 'I%' OR CITY LIKE 'O%' OR CITY LIKE 'U%' );

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE ( CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE 'I%' OR CITY LIKE 'O%' OR CITY LIKE 'U%' );