Select All data of a table

Select All data of a table

Instructor-svgAl-Mamun Sarkar
Mar 26 , 2020

Select All data of a table. Show all data from the city table. This is the solution of the HackerRank Select All SQL problem.

 

Table Name: CITY 

Table structure:

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

 

SQL Query:

SELECT * FROM CITY;

 

  • Share On:
  • fb
  • twitter
  • pinterest
  • instagram