관리 메뉴
홍동이의 성장일기
[HackerRank] Weather Observation Station 3 본문
Weather Observation Station 3 | HackerRank
Query a list of unique CITY names with even ID numbers.
www.hackerrank.com
select distinct city
from station
where id%2=0;
💡 개념정리
DISTINCT: 지정된 컬럼명이 중복되지 않고 반환된다.
728x90
'Tool > SQL 코딩테스트 풀이' 카테고리의 다른 글
| [LeetCode] 1179. Reformat Department Table (0) | 2023.08.12 |
|---|---|
| [LeetCode] 602. Friend Requests II: Who Has the Most Friends (0) | 2023.04.17 |
| [HackerRank] Type of Triangle (0) | 2023.04.17 |
| [HackerRank] The PADS (0) | 2023.04.17 |
| [LeetCode] 175. Combine Two Tables (0) | 2023.04.17 |
'Tool/SQL 코딩테스트 풀이' Related Articles
more
Comments