728x90
❓ Question
https://www.hackerrank.com/challenges/weather-observation-station-3
❗ Answer
SELECT DISTINCT(city)
FROM station
WHERE id%2 = 0;
📌 Discussion
- DISTINCT로 중복된 레코드 제거
'SQL 문제풀이' 카테고리의 다른 글
[해커랭크 SQL] Basic Select - Weather Observation Station 6 (0) | 2023.08.16 |
---|---|
[해커랭크 SQL] Basic Select - Weather Observation Station 4 (0) | 2023.08.16 |
[해커랭크 SQL] Basic Select - Weather Observation Station 1 (0) | 2023.08.16 |
[해커랭크 SQL] Basic Select - Japanese Cities' Names (0) | 2023.08.16 |
[해커랭크 SQL] Basic Select - Japanese Cities' Attributes (0) | 2023.08.16 |