From the course: SQL for Non-Programmers

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Retrieving data with SELECT

Retrieving data with SELECT - SQL Tutorial

From the course: SQL for Non-Programmers

Start my 1-month free trial Buy for my team

Retrieving data with SELECT

“

Are you ready to try your hand at SQL code? Let's begin exploring the Select statement together. I already have the chapter two part two begin file open. In this first section, I'll start typing SELECT *. The star stands for all, in this case, all rows and columns in our table. And I'll go to the next line. FROM oliveoil.sales to specify the table I want to use. We have access to multiple tables in our database. But we are going to begin using only the sales table to provide the management team with the insights they need. We specify the table by first listing the database name, oliveoil, followed by a period, and then the table name, sales. We close our statement with a semicolon, which is required in SQLite, but is also an overall best practice you should use whenever writing SQL queries. Press the blue Play button right above your code and towards the top left to execute the query. The output is shown across the bottom here in a table format in the grid view section, and the status…

Contents