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 3
Weather Observation Station 3
Sort by
recency
|
1745 Discussions
|
Please Login in order to post a comment
select distinct CITY from STATION where ID%2=0;
SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0
for even number %2=0
SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0 ORDER BY CITY;
SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0
SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0; This query selects distinct CITY names from the STATION table where the ID number is even (i.e., ID % 2 = 0). It excludes duplicate entries from the result set.