Pavithra's Space
  • Home
  • Skills
    • SQL
    • HackerRank
      • Revising the Select Query I
      • Revising the Select Query II
      • Select All
      • Select By ID
      • Japanese Cities' Attributes
      • Japanese Cities' Names
      • Weather Observation Station 1
      • Weather Observation Station 3
      • Weather Observation Station 4
      • Weather Observation Station 5
      • Weather Observation Station 6
      • Weather Observation Station 7
      • Weather Observation Station 8
      • Weather Observation Station 9
      • Weather Observation Station 10
      • Weather Observation Station 11
      • Weather Observation Station 12
      • Higher Than 75 Marks
      • Employee Names
      • Employee Salaries
Powered by GitBook
On this page
  1. Skills
  2. HackerRank

Select All

PreviousRevising the Select Query IINextSelect By ID

Last updated 1 year ago

Query all columns (attributes) for every row in the CITY table.

The CITY table is described as follows:

Solution:

SELECT * FROM CITY;

Explanation:

This query retrieves all columns from the CITY table, fetching all the data stored in that table without any conditions or filters applied.

Select All | HackerRankHackerRank
Logo