SQL SELECT Tutorial

SQL Tutorial: SELECT Statement with Pictures

Simple Tutorial on how to use the SELECT statement in SQL

SQL Bootcamp: Live & Hands-on, In NYC or Online, Learn From Experts, Free Retake, Small Class Sizes,  1-on-1 Bonus Training. Named a Top Bootcamp by Forbes, Fortune, & Time Out. Noble Desktop. Learn More.

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

How to Learn SQL

Master SQL with hands-on training. SQL is one of the most in-demand programming languages and is used across a variety of professions.

Yelp Facebook LinkedIn YouTube Twitter Instagram