From the course: Querying Microsoft SQL Server 2022

Unlock the full course today

Join today to access over 24,200 courses taught by industry experts.

Solution: Write a SELECT query

Solution: Write a SELECT query - SQL Server Tutorial

From the course: Querying Microsoft SQL Server 2022

Start my 1-month free trial Buy for my team

Solution: Write a SELECT query

“

(upbeat music) - I hope you were able to locate all of the requested work orders. Let's go ahead and work through the solution. I'm going to go into my AdventureWorks database and find the table that we want to work with. And that was the production.workorder table. Let me just scroll down here and we'll find it right there. All right, I'll go ahead and expand that open and find our columns. So these are all the columns that we can work with. I actually like to run a simple select query just to pull everything out of the table so I can see what I'm starting with. So we'll just say select * from production.workorder. And we'll go ahead and execute that. So these are the columns and all the data that we can work with. Now for this question or for this challenge I asked to identify the work order. So we want to pull this work order ID column in our final solution. We also wanted to find just the work orders that had…

Contents