SQL Select By ID

Author: Al-mamun Sarkar Date: 2020-03-26 15:07:59

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;