SQL Select Query - Select all column
Author: Al-mamun Sarkar
Date: 2020-03-26 14:55:22
SQL Select Query - Select all columns. Show all columns of USA from the city table which population is greater than 100000. This is the solution of the HackerRank Revising the Select Query I 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;