asterisk-solid All courses are temporarily held live online with an extended free retake period. Learn More.

window-close-line
Hero image for SQL SELECT Tutorial

SQL SELECT Tutorial

SQL Tutorial: SELECT Statement with Pictures

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

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:

SQL SELECT Result

Master SQL in hands-on training