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 ;


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

If we wanted to use a SQL query to retrieve the player and team of each player, we would write the following:

SQL Select

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:


Master SQL in hands-on training