반응형
SQL > Basic Select > Select By ID
Problem
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
반응형
'CODING TEST > SQL : HackerRank' 카테고리의 다른 글
| [MySQL] Weather Observation Station 4 (0) | 2021.03.31 |
|---|---|
| [MySQL] Weather Observation Station 3 (0) | 2021.03.30 |
| [MySQL] Weather Observation Station 1 (0) | 2021.03.30 |
| [MySQL] Japanese Cities' Names (0) | 2021.03.29 |
| [MySQL] Japanese Cities Attributes (0) | 2021.03.29 |
| [MySQL] Select All (0) | 2021.03.27 |
| [MySQL] Revising the Select Query II (0) | 2021.03.26 |
| [MySQL] Revising the Select Query I (0) | 2021.03.26 |
댓글