https://www.hackerrank.com/challenges/select-by-id/problem?isFullScreen=true
코드설명
SELECT를 활용합니다.
ID = 1661인 도시의 모든 컬럼을 조회합니다.
ORACLE 코드
SELECT *
FROM CITY
WHERE ID = 1661;
'SQL > HackerRank' 카테고리의 다른 글
[SQL][HackerRank] Weather Observation Station 1 - SELECT ORACLE (0) | 2024.09.25 |
---|---|
[SQL][HackerRank] Japanese Cities' Names - SELECT ORACLE (0) | 2024.09.24 |
[SQL][HackerRank] Japanese Cities' Attributes - SELECT ORACLE (0) | 2024.09.24 |
[SQL][HackerRank] Select All - SELECT ORACLE (0) | 2024.09.20 |
[SQL][HackerRank] Revising the Select Query I - SELECT + LIKE + REGEXP_LIKE ORACLE (0) | 2024.09.20 |