본문 바로가기
DB/SQL

HackerRank_09. Weather Observation Station 3

by _S0_H2_ 2020. 6. 11.
728x90
반응형

문제 : Query a list of CITY names from STATION with even ID numbers only. You may print the results in any order, but must exclude duplicates from your answer.

 

select distinct CITY
from STATION
where MOD(ID,2) = 0;

 

728x90
반응형