Learn SQL/

...

/

Selecting Display Fields and Specifying the Data Source

Selecting Display Fields and Specifying the Data Source

Learn the basics of the SELECT statement.

We'll cover the following...

Selecting specific display fields

Let’s assume that the following dataset is stored in a relational database table named SalesData. 

Press + to interact
SalesData table
SalesData table

We want to generate the following report: 

Press + to interact
A sample report
A sample report

Let’s start with finding the answer to the first question: 

Q

(Select all that apply.) What are the fields/attributes we want to show in our result set?

A)

SaleID

B)

SalesPerson

C)

ProductCategory

D)

SaleDate

E)

ProductName

F)

SalesAmount

When creating an SQL query, the goal is to precisely select the necessary information. Often, it’s as straightforward as shown in this exercise. Yet, occasionally, it can also be quite challenging!

Let’s answer the following question:

Q

Below is a list of keywords. Your task is to choose the keyword that corresponds to retrieving the identified field in the result set:

SalesPerson, SalesData, ProductName, SalesAmount

A)

FROM

B)

SELECT

C)

WHERE

Now let’s answer the second ...