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

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

LogoSelect All | HackerRankHackerRank

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.

PreviousRevising the Select Query IINextSelect By ID

Last updated 1 year ago