Question
Query all columns for a city in CITY with the ID 1661.
The CITY table is described as follows:
My Answer
SELECT *
FROM CITY
WHERE ID = 1661;
Result
출처 : https://www.hackerrank.com/challenges/select-by-id/problem
Select By ID | HackerRank
Query the details of the city with ID 1661.
www.hackerrank.com
'SQL > HackerRank' 카테고리의 다른 글
[MySQL/HackerRank] Japanese Cities' Names (0) | 2022.07.24 |
---|---|
[MySQL/HackerRank] Japanese Cities' Attributes (0) | 2022.07.24 |
[MySQL/HackerRank] Select All (0) | 2022.07.10 |
[MySQL/HackerRank] Revising the Select Query II (0) | 2022.07.07 |
[MySQL/HackerRank] Revising the Select Query I (0) | 2022.07.07 |