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
|
1979 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT CITY FROM STATION WHERE ID %2 =0 ;
select distinct city from station where RIGHT(DIGITS(id), 1) in ('0', '2', '4', '6', '8');
SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;
SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;
you need to know that for duplicant we need to use distinct clause answer for this is select distinct city from station where id % 2 = 0;