[HackerRank SQL] Weather Observation Station 3 (Oracle)

Weather Observation Station 3

 

Problem

 

Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.

The STATION table is described as follows:

(ID 번호가 짝수인 도시에 대해 STATION에서 CITY 이름의 목록을 작성하시오. 결과를 아무 순서로나 출력하되, 답변에서 중복을 제외하시오.)

 

Solution(Oracle)

SELECT DISTINCT CITY FROM STATION
    WHERE MOD(ID, 2) = 0;

---

MOD 함수 - 숫자를 나눈 나머지 값 구함

MOD([나눗셈 될 숫자(필수)], [나눌 숫자(필수)])

 

DISTINCT - 중복 데이터 제거

SELECT DISTINCT DEPTNO FROM EMP;

 

https://www.hackerrank.com/challenges/weather-observation-station-3/problem

Weather Observation Station 3 | HackerRank