본문 바로가기

SQL/HackerRank

[MySQL/HackerRank] Select By ID

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