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
|
1789 Discussions
|
Please Login in order to post a comment
Can any one tell what is the output of MOD(ID,20)=0 and why cannot we use
SELECT DISTINCT CITY FROM STATION WHERE ID IS NOT NULL;
SELECT DISTINCT CITY FROM STATION WHERE MOD(ID,2)=0 ORDER BY CITY ASC;
For MS SQL Server select distinct (city) from station where id % 2 =0;
select distinct(city) as d_id from station where mod(id,2)=0 order by d_id asc;