From the course: Learning Microsoft SQL Server 2019

Unlock the full course today

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

Create a SELECT statement

Create a SELECT statement - SQL Server Tutorial

From the course: Learning Microsoft SQL Server 2019

Start my 1-month free trial

Create a SELECT statement

“

- [Instructor] When it's time to start retrieving information that's stored in your tables, you'll turn to an activity called querying the database. In order to query the database, you'll need to issue commands written in a language called transact sequel or T sequel, if you prefer the shorter name. To get our first look at T sequel, I'm going to drill into the WideWorldImporters database and expand the tables folder. Then I'm going to find the Sales.Orders table, right click on it and choose Select top 1000 Rows. This will issue a T sequel query to the database and return the first 1000 records from this particular table. On the top of the query window, we had the exact syntax of the query and on the bottom we have the results. Let's focus our attention on the top portion of this window. It begins with the key word Select. This Select clause tells the database what columns are going to be returned. In this case, we're returning the OrderID, CustomerID, SalespersonID and all these…

Contents