From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Building distinct queries

Building distinct queries

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Building distinct queries

“

- [Instructor] We don't always have access to every single table or data system in an organization. And you may find that you need to create data from the data you do have. Knowing how to create unique or distinct queries can help you achieve these datasets. Let me show you what I mean. Let's take a look at the invoices detail data. I'll go ahead and double-click that. And I want you to take a look at the StockItemID and the Description. We don't have access to the products system. However, from our invoices detail, we can see what's been invoiced by looking at the stock item and the description. Okay, let's go ahead and write a query. I'll go to create, I'll choose query design. I'll go ahead and double-click InvoicesDetails. And then I'll double-click StockItemID, and I'll double-click Description. I know I want to see these sorted, so I'll go ahead and clicking in the sort line and sort the StockItemID ascending. This'll put all of them together. Go ahead and run your query. And…

Contents