Hello coders, today we are going to solve Select By ID HackerRank Solution in SQL.
Problem
Query all columns for a city in CITY with the ID 1661.
The CITY table is described as follows:
CITY
| Field | Type |
| ID | NUMBER |
| NAME | VARCHAR2(17) |
| COUNTRYCODE | VARCHAR2(3) |
| DISTRICT | VARCHAR2(20) |
| POPULATION | NUMBER |
Solution – Select By ID in SQL
SELECT * FROM CITY WHERE ID = 1661;
Disclaimer: The above Problem (Select By ID) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.