https://www.hackerrank.com/challenges/select-by-id
Select By ID | HackerRank
Query the details of the city with ID 1661.
www.hackerrank.com
Query all columns for a city in CITY with the ID 1661.
The CITY table is described as follows:

WHERE문 사용 문제
ID가 1661인 것만 출력
코드
더보기
SELECT *
FROM CITY
WHERE ID = 1661;
728x90
'서버 > MYSQL' 카테고리의 다른 글
| [MYSQL] HACKERRANK - Japanese Cities' Names (0) | 2022.05.31 |
|---|---|
| [MYSQL] HACKERRANK - Japanese Cities' Attributes (0) | 2022.05.31 |
| [MYSQL] HACKERRANK - SELECT ALL (0) | 2022.05.31 |
| [MYSQL] HACKERRANK - Revising the Select Query II (0) | 2022.05.31 |
| [MYSQL] HACKERRANK - Revising the Select Query I (0) | 2022.05.31 |
댓글