Weather Observation Station 6

Sort by

recency

|

4892 Discussions

|

  • + 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%';

  • + 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 LOWER(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%';

                     ( second method)
    

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