You have a table and you want to select some data from it.
To select data from a database we use the SELECT statement.
Simple SELECT syntax –
SELECT * FROM city;
This above query will select every rows and columns from the city table. The * asterisks in the SELECT statement is a wildcard for selecting every columns in the city table. And we use the FROM Clause to tell SQL, from which table to select the data.
SELECT only a Subset of column –
Using the wildcard is good if you want to see the structure of the table but might not be always useful. To SELECT only few columns from a table you list the name of the columns separated by comma after the SELECT statement.
Let’s say I want to only select the Name and CountryCode column. Then I will use –
SELECT NAME, CountryCode FROM city;
This query will only return the columns that we specified in the SELECT statement.
For more SQL Tutorial subscribe to our blog below.