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.
Weather Observation Station 7
Weather Observation Station 7
Sort by
recency
|
3096 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT city
FROM station
WHERE right(city, 1) IN ('A', 'E', 'I', 'O', 'U');
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
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;
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');
SQL Server select distinct city from station where right(city,1) in ('a','e','i','o','u');