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