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.
If we wanted to use a SQL query to retrieve the player and team of each player, we would write the following:
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:
