Weather Observation Station 7

Sort by

recency

|

3096 Discussions

|

  • + 0 comments

    SELECT DISTINCT city
    FROM station
    WHERE right(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%') AND LAT_N IS NOT NULL AND LONG_W IS NOT NULL; query Can you somone correct this

  • + 0 comments

    Can you somone correct this below query 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%') AND LAT_N IS NOT NULL AND LONG_W IS NOT NULL;

  • + 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

    SQL Server select distinct city from station where right(city,1) in ('a','e','i','o','u');