From the course: SQL Server Fundamentals: Master Basic Query Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Reading from a single table in SQL

Reading from a single table in SQL - SQL Tutorial

From the course: SQL Server Fundamentals: Master Basic Query Techniques

Start my 1-month free trial

Reading from a single table in SQL

“

- [Instructor] We have finally arrived at the coding portion of our show, and we're going to start with the most basic operation, which is reading from a single table. To do that, we're going to build what's known as a select statement, where you're going to select what columns you want to look at, and tell SQL Server what tables those columns should be coming from using a from clause. So let's move over to SSMS so we can see this in action. As you can see, I've already connected to the server on my machine and I'm going to go ahead and expand my Databases folder by clicking on the plus sign to the left. And I'm going to be using the sandbox database for this demo, and expand that in the same way. And then lastly, we're going to look at our list of tables available. And if you ran the data script attached to chapter one, your database should look exactly like this as well. So to write my first query, first I'm going to select the database I want to work off of, which is the sandbox…

Contents