HackerRank SQL Preparation: Select All(MySQL)

Problem Statement:

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

Link: HackerRank - Select All SQL

Solution:

SELECT * FROM CITY;

Explanation:

• 
  SELECT *: The asterisk (*) is a wildcard character in SQL that means "all columns." This part of the query specifies that you want to retrieve all columns from the table.


• 
  FROM CITY: Indicates that you are selecting data from the CITY table.

This query will return all the columns for every row in the …

attributes city every hackerrank mysql part problem query solution sql table writeups you