SQL Select By ID

SQL Select By ID. Show all columns in which id is 1661 from the city table. This is the solution of the HackerRank Select By ID SQL problem.

 

Table Name: CITY 

Table structure:

Field	Type
ID	NUMBER
NAME	VARCHAR
COUNTRYCODE	VARCHAR
DISTRICT	VARCHAR
POPULATION	NUMBER

 

SQL Query:

SELECT * FROM CITY 
WHERE ID = 1661;