Simple Tutorial on how to use the SELECT statement in SQL
SELECT Statement
-
The SELECT statement is our first input whenever we write a query to retrieve data from a table.
-
This statement specifies which columns or data we want to retrieve from our table.
-
Syntax: SELECT * FROM table ;
Example
Let’s say we have a basketball league and we keep records of each player, which team they are on, and their basic statistics.
![Stats Table](/images/stats_table.PNG)
If we wanted to use a SQL query to retrieve the player and team of each player, we would write the following:
![SQL Select](/images/sql-select.PNG)
We are saying that we’d like to retrieve the player and team columns from the Stats table. Once we hit enter and run, our result should be as follows:
![SQL SELECT Result](/images/select-result.PNG)