HackerRank - Select By ID

April - 25/2025

Problem:

Query all columns for a city in CITY with the ID 1661.

The CITY table is described as follows:

Field	Type
ID	NUMBER
Name	VARCHAR2(17)
COUNTRYCODE	VARCHAR2(3)
DISTRICT	VARCHAR2(20)
POPULATION	NUMBER

# Solution

            
    SELECT *
    FROM CITY
    WHERE ID = '1661';

Post:

2025-04 - Japanese Cities' Attributes;